摘要:
我有一个表CREATE TABLE `test1` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `desc` varchar(100) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8(1)以下查询会报错误:[Err] 1221 - Incorrect usage of UNION and ORDER BYselect * from test1 where name like 'A%' o 阅读全文