我用powerdesigner导出一个生成表的sql语句
create table course
(
courseId int(10) unsigned not null auto_increment,
account national varchar(10) not null,
courseTime national varchar(200) not null,
courseName national varchar(200)
);
alter table course comment 'InnoDB free: 2048 kB';
alter table course
add primary key (courseId);
但我想要的是这样的(注意主码的设置)
create table course
(
courseId int(10) (primary key) unsigned not null auto_increment primary key,
account national varchar(10) not null,
courseTime national varchar(200) not null,
courseName national varchar(200)
);
alter table course comment 'InnoDB free: 2048 kB';
怎么设置?