mysql语法注意_mysql语法错误请教

CREATETABLEbookmark(userchar(20)NOTNULLdefault'',titlechar(70)NOTNULLdefault'',urlchar(200)NOTNULLdefault'',descriptionmediumtextdefaultNULL,privateenum('0','1')defaultNU...

CREATE TABLE bookmark (

user char(20) NOT NULL default '',

title char(70) NOT NULL default '',

url char(200) NOT NULL default '',

description mediumtext default NULL,

private enum('0','1') default NULL,

datetime stamp(14) NOT NULL,

childof int(11) NOT NULL default '0',

id int(11) NOT NULL auto_increment,

deleted enum('0','1') NOT NULL default '0',

favicon varchar(200),

public enum('0','1') NOT NULL default '0',

PRIMARY KEY (id),

FULLTEXT KEY title (title,url,description)

)

报错：

#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

'stamp(14) NOT NULL, childof int(11) NOT NULL default '0', id int(11) NOT' at

line 7

第7行打错了，应该是datetime stamp(14) NOT NULL

然后报错

#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

'stamp(14) NOT NULL, childof int(11) NOT NULL default '0', id int(11) NOT' at

line 7

展开