How do I delete the nth row from a table?

Use delete and the virtual column i:

delete from `t where i = n

Don’t forget the backquote if you intend to delete-in-place.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.