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.