delete mysql 语法_mysql delete where 语法无法使用

表信息:SETFOREIGN_KEY_CHECKS=0;--------------------------------Tablestructurefor`users`------------------------------DROPTABLEIFEXISTS`users`;CREATETABLE`users`(`ID`int(1...

表信息:SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `users`-- ----------------------------DROP TABLE IF EXISTS `users`;CREATE TABLE `users` ( `ID` int(11) NOT NULL auto_increment, `userName` varchar(20) character set utf8 NOT NULL, `userPass` varchar(20) character set utf8 NOT NULL, `headId` int(11) default NULL, `sex` int(10) unsigned zerofill default NULL, `birthTime` datetime default NULL, `address` varchar(200) character set utf8 default NULL, `createTime` datetime default NULL, `State` int(10) unsigned zerofill default NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;-- ------------------------------ Records of users-- ----------------------------INSERT INTO `users` VALUES ('1', 'LYP', '123', '0', '0000000000', '1988-08-21 00:00:00', '地球上', '2009-07-27 20:10:13', '0000000000');INSERT INTO `users` VALUES ('2', 'LYP', '123', '0', '0000000000', '1988-08-21 00:00:00', '地球上', '2009-07-27 20:11:39', '0000000000');SQL 语句delete users where id='2'错误信息: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 'where id='2'' at line 1

展开