文章目录[隐藏]
sql语句怎么写啊？
delete from visitrecord where id in (select top 100 from visitrecord order by id asc)
这样写有什么错误吗？
回复讨论(解决方案)
delete from visitrecord where id in (select id from visitrecord order by id asc limit 100)
delete from visitrecord limit 100
delete from visitrecord where id in (select id from visitrecord order by id asc limit 100)
This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
delete from visitrecord where id in (select top 100 from visitrecord order by id asc)
你的~来1源gaodai#ma#com搞*代#码1网搞代gaodaima码这个写法是sqlserver的
mysq写法如下
delete from visitrecord where id in (select id from visitrecord order by id asc limit 100);
都是大神啊，我轻飘飘的路过~~~
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：删除前100条数据，根据主键ID排序。
转载请注明原文链接：删除前100条数据，根据主键ID排序。
