delete the last row in a table using sql query?

Question

I am trying to delete the last record in the table named "marks" in the database using MySql query.
The query I tried for this is as follows:

DELETE MAX(`id`) FROM `marks`;

There are 8 columns in the table. I want to delete the last column without specifying id, as in:

DELETE FROM marks where id=8;

After deleting the 8th record, I want to delete the 7th; after that 6th and so on, up to 1st record without specifying the id manually.

Answer 1

If id is auto-increment then you can use the following

delete from marks
order by id desc limit 1

Answer 2

@Abhshek's Answer is right and works for you but you can also try the following code if the id is not increment

DELETE FROM MARKS WHERE ID=(SELECT MAX(id) FROM MARKS)