create table news
(id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
title varchar(40) not null,
content text not null,
dates datetime not null,
)
auto_increment=1;
请问下这个写法错在哪里呢?
(id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
title varchar(40) not null,
content text not null,
dates datetime not null,
)
auto_increment=1;
请问下这个写法错在哪里呢?
CREATE TABLE BUYORDER
(
ID int not null auto_increment,
APPLYSN varchar(15),
PARTNO varchar(15),
ORDERSN varchar(15),
primary key (ID)
);这个是powerdesign自动生成的;可以用
是最后一个字段定义的not null 加了个逗号