摘要：select count(*),t1.`name` from test_id t1INNER JOIN test_id t2on t1.id >= t2.idgroup by t1.id,t1.`name`HAVING count(*) < t1.idorder by t1.idlimit 1;se...
阅读全文
posted @ 2014-12-16 12:46
12 2014 档案
摘要：CREATE TABLE `test_id` (`id` int(11) NOT NULL DEFAULT 0 ,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'XX' ,PRIMARY K...
阅读全文
posted @ 2014-12-16 12:25
