Re: Delete nth row in database

[Rick James]

DELETE FROM table_name WHERE column_name = 'pear';

As peter says, there no concept of "second row". Instead, you need to supply yourself with some kind of handle so that you can access specific row(s).

In the current situation (as far as you have shown us), the only 'handle' is the column and the value 'pear'.