Php MySQL - Delete all rows by limit

Question

I want to delete all rows expect the 5 first rows.

/*example of the $count is equal to 5 */
$count=$xml->table->records->attributes();

This is my table:

The result would be like this

The above 5 will be deleted.

Charaf JRA · Accepted Answer · 2013-09-16 00:25:58Z

2

Try this query :

DELETE
FROM Table1
WHERE xml_id  NOT IN
    (SELECT xml_id  
     FROM Table1
     LIMIT 5)

answered Sep 16, 2013 at 0:25

Charaf JRA

8,3551 gold badge36 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1