程式記錄，轉載，心得體會

摘要： 我有一个表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 阅读全文