create table personal

yebinlei

drop table t_theme;

create table netbank.t_theme
(id_theme  serial not null ,
theme    varchar(50),
choice_num integer(4),
choice1 varchar(50),
choice2 varchar(50),
choice3 varchar(50),
choice4 varchar(50),
choice5 varchar(50),
choice6 varchar(50),
standard_answer varchar(2),

);
如果要制定id_theme 为主键，，应该如何加？
多谢！

xy-coordinate

原帖由 "yebinlei" 发表：
drop table t_theme;

create table netbank.t_theme
(id_theme  serial not null ,
theme    varchar(50),
choice_num integer(4),
choice1 varchar(50),
choice2 varchar(50),
choice3 varchar(50),
primary key (id_theme ) );

或者：
create table netbank.t_theme
（id_theme  serial not null primary key ,
theme    varchar(50),
choice_num integer(4),
choice1 varchar(50),
choice2 varchar(50),
choice3 varchar(50),
……）；
如果主键有多个，必须用前一种！