Deletes the first 100 data, sorted by primary key ID.

How do you write SQL statements?

Delete from Visitrecord where ID in (select top of Visitrecord ORDER by ID ASC)

Is there any mistake in writing this?

Reply to discussion (solution)

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 of Visitrecord ORDER by ID ASC)
This is the SQL Server you're writing.

MYSQ the following wording
Delete from Visitrecord where ID in (the Select ID from Visitrecord the ORDER by ID ASC limit 100);

It's all great gods, I'm passing by.

