CREATE TABLE tabNotices(
id bigint NOT NULL AUTO_INCREMENT ,
state int NOT NULL ,
release datetime NOT NULL ,
subject varchar( 50 ) NOT NULL ,
content text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;
一运行到release datetime 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 'release datetime NOT NULL ,
subject varchar (50) NOT NULL ,
content text NOT' at line 4
CREATE TABLE tabNews (
id bigint NOT NULL auto_increment ,
state int NOT NULL ,
`release` datetime NOT NULL ,
`subject` varchar (40) NOT NULL ,
`digest` varchar (200) NOT NULL ,
content text NOT NULL ,
PRIMARY KEY (id)
) TYPE=MyISAM;作者: Snowpine 时间: 2007-8-25 17:04
