Create table WebOa.parts(id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
partname varchar(40),
partcomments varchar(240),
parentpart int,
partwholename varchar(100),
partabstract varchar(240),
partdetail text,
user varchar(40),
part varchar(40),
pubtime varchar(40),
check int default 1
);
出错如下:
[Err] 1064 - 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 'int default 1
)' at line 11
[Err] Create table WebOa.parts(id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
partname varchar(40),
partcomments varchar(240),
parentpart int,
partwholename varchar(100),
partabstract varchar(240),
partdetail text,
user varchar(40),
part varchar(40),
pubtime varchar(40),
check int default 1
);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
partname varchar(40),
partcomments varchar(240),
parentpart int,
partwholename varchar(100),
partabstract varchar(240),
partdetail text,
user varchar(40),
part varchar(40),
pubtime varchar(40),
check int default 1
);
出错如下:
[Err] 1064 - 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 'int default 1
)' at line 11
[Err] Create table WebOa.parts(id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
partname varchar(40),
partcomments varchar(240),
parentpart int,
partwholename varchar(100),
partabstract varchar(240),
partdetail text,
user varchar(40),
part varchar(40),
pubtime varchar(40),
check int default 1
);
[Msg] Finished - Unsuccessfully
--------------------------------------------------
partname varchar(40),
partcomments varchar(240),
parentpart int,
partwholename varchar(100),
partabstract varchar(240),
partdetail text,
`user` varchar(40),
part varchar(40),
pubtime varchar(40),
`check` int default 1 #-- changed by ACMAIN,check is reserve word
);