如何删除一个表单记录的最新五条记录?

rt
---------------------------------------------------------------

delete from user_info where uid in(select top 5 uid from user_info order by regtime desc)
你看这样可以吗,我是用的字查询,不知道谁还有更好的办法:)
---------------------------------------------------------------

设一个自动增加的列,然后选出5个最大的删除。

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus