mysql> create table produceinfo(
-> produceid number not null auto_increment,
-> producename varchar(30) not null,
-> brandname varchar(50) not null,
-> produceprice double not null,
-> maininfo varchar(600) not null,
-> produceimg varchar(30) not null,
-> leftcount int(5) not null,
-> key(produceid)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'numbe
r not null auto_increment,
producename varchar(30) not null,
brandname varc' at line 2
问题出在哪?请指教下,谢谢!
-> produceid number not null auto_increment,
-> producename varchar(30) not null,
-> brandname varchar(50) not null,
-> produceprice double not null,
-> maininfo varchar(600) not null,
-> produceimg varchar(30) not null,
-> leftcount int(5) not null,
-> key(produceid)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'numbe
r not null auto_increment,
producename varchar(30) not null,
brandname varc' at line 2
问题出在哪?请指教下,谢谢!
-> produceid number not null auto_increment, \
-> producename varchar(30) not null, \
-> brandname varchar(50) not null,\
-> produceprice double not null,\
-> maininfo varchar(600) not null,\
-> produceimg varchar(30) not null,\
-> leftcount int(5) not null,\
-> key(produceid)\
-> );
`produceid number` int not null auto_increment,
producename varchar(30) not null,
brandname varchar(50) not null,
produceprice double not null,
maininfo varchar(600) not null,
produceimg varchar(30) not null,
eftcount int(5) not null,
key(`produceid number`) )