mysql
peng13123
这个作者很懒,什么都没留下…
展开
-
mysql where limit
update car set manager_id = 1 where manager_id = 2 limit 60;原创 2013-12-06 14:08:55 · 123 阅读 · 0 评论 -
查询表中重复字段数据的id
[code="java"]select id_,price_ from ap_car a where open_ = 1 and exists( select 1 from ap_car where a.price_=price_ group by price_ having count(*)>1 and min(id_)原创 2014-04-15 11:16:25 · 242 阅读 · 0 评论