报错提示是:
ERROR 1064 (42000) at line 642: 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
这个表的sql语句是
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;
ERROR 1064 (42000) at line 642: 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
这个表的sql语句是
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;
解决方案 »
- 从数据库读出的数据,只显示最后一条,且把其他的都覆盖了。
- jdbc连接mysql问题,请高手赐教
- windows 2003上安装MySQL5.1.35报错
- 求oracle语句转换mysql!~
- 导入txt 用的是sqlyog tools/import sql statements
- 请教mysqldump的远程数据备份问题
- 请问mysql字段名,若是系统关键字,比如MOD,如何转义,象sqlserver一样加[],但是mysql加[]好象不行
- c++访问mysql相关
- 如何将一条带有自增加的update语句和insert语句合并为replace
- 出现这种问题:SSH Error: FATAL ERROR: Unable to authenticate
- vc6.0中用C API连接mysql一示例代码(语言是c++)
- can't return a result set in the given context
ERROR 1292 (22007) at line 1205: Incorrect datetime value: '' for column 'duedat
e' at row 1又不通用吗,1205段的内容是INSERT INTO tabMemberAccounts ( id , state , balance , graceday , pastdue , ucash , ucredit , purchases , cdeposit , d uedate ) VALUES ( '1' , '1' , '-1000000.0000' , '7' , '-1000000.0000' , '.0000' , '.0000' , '.0000' , '.0000' , '' );