Question

#1064 - You have an error in your SQL syntax;我要把MYSQL数据库中的身份证号小写全部改成大写

错误提示：#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 'LIKE '%X%' WHERE `stu_info`.`id` LIKE '%x%' LIMIT 0 , 30' at line 1

我的代码：
UPDATE `guo`.`stu_info` SET `id` LIKE '%X%' WHERE `stu_info`.`id` LIKE '%x%' LIMIT 0 , 30

Answer 1

改成CREATE TABLE `uchome_car_favi` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT,
`carid` mediumint(11) NOT NULL DEFAULT '0',
`uid` mediumint(11) NOT NULL,
`username` char(20) NOT NULL DEFAULT '0',
`dateline` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;
原因是PRIMARY KEY (`id`)后面多了个“，”希望有帮助。小郭蝈蝈可到chinaunix,365testing逛逛