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);
你的这个写法是sqlserver的mysq写法如下
delete from visitrecord where id in (select id from visitrecord order by id asc limit 100);