超级郁闷,往Mysql里面insert一条记录都不行

[keyend]

CREATE TABLE `c_admin` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`name` varchar(255) default NULL,
`traf` datetime default NULL,
`addr` varchar(255) default NULL,
`swee` bit(1) default NULL,
`slog` datetime default NULL,
`slogIP` varchar(255) default NULL,
`update` datetime default NULL,
`cdate` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2;


mysql> INSERT INTO c_admin (user,pass,name,traf,[update],cdate) VALUES ('adddd','d41d8cd98f00b204e9800998ecf8427e','123','2009-06-22 08:42:31','2009-06-22 08:42:31','2009-06-22 08:42:31');

ERROR 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 '[update],cdate) VALUES ('addd','d41d8cd98f00b204e9800998ecf8427e','aaa','20' at line 1

[lgzxz999]

INSERT INTO c_admin (user,pass,name,traf,[update],cdate)
变成
INSERT INTO c_admin (user,pass,name,traf,update,cdate)
看看

[tfxg]

INSERT INTO c_admin (user,pass,name,traf,[update],cdate) VALUES ('adddd','d41d8cd98f00b204e9800998ecf8427e','123','2009-06-22 08:42:31','2009-06-22 08:42:31','2009-06-22 08:42:31');

上面的[update]處錯誤,改成
INSERT INTO c_admin (user,pass,name,traf,`update`,cdate) VALUES ('adddd','d41d8cd98f00b204e9800998ecf8427e','123','2009-06-22 08:42:31','2009-06-22 08:42:31','2009-06-22 08:42:31');

[littlebirds]

[update]换成"update"试试。

[tfxg]

直接從來創建語句抄 `update`，因為是關鍵字

[keyend]

一样不行

[keyend]

字符集是:utf8 -- UTF-8 Unicode
整理:utf8_general_ci

用Navicat看的

[keyend]

可以了,4楼兄弟的``号我以为是单引号,抱歉,已解决

[lgzxz999]

谁让你用update做字段名的,呵呵..大哥,最好能换个名字吧..

不然就包上,像mysql要用`update`

[littlebirds]

你自己查查，肯定是[update]附近有错。