刪除前100條資料，根據主鍵ID排序。

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)
你的這個寫法是sqlserver的

mysq寫法如下
delete from visitrecord where id in (select id from visitrecord order by id asc limit 100);

都是大神啊，我輕飄飄的路過~~~

