摘要:
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 懒人ABC 阅读(519) 评论(0) 推荐(0)
摘要:
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 懒人ABC 阅读(519) 评论(0) 推荐(0)
摘要:
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 懒人ABC 阅读(374) 评论(0) 推荐(0) |
||