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
`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
变成
INSERT INTO c_admin (user,pass,name,traf,update,cdate)
看看
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');
整理:utf8_general_ci用Navicat看的