mysql delete and php

[wrathican]

hi there people,

 

i need a single mysql query that would delete all but the first row in a table.

 

thanks

 

Wrathican

[trq]

Define first row.

[envexlabs]

You'll have to figure out the id of the id of the first row:

 

$query = mysql_query('SELECT `id` FROM `table` ORDER BY `id` ASC');

$result = mysql_fetch_assoc($query);

 

$delete = mysql_query("DELETE FROM `table` WHERE `id` = '$result[id]' LIMIT 1");

[trq]

If you where going to use that type of logic you could simply use...

 

DELETE FROM tbl WHERE id NOT IN(MIN('id']));