Help: Deleting just one row in mysql...

I have a cron job which I want to remove just one row from the database -the top row.

How do I just remove/delete one row from a database?

This is code for delete all I think, so how do I make it just delete one?
-(Once that is sorted I can fix this rest -delete one ORDER BY Time DESC)

DELETE FROM `Queue`

So how do I?

Thanks,

James

 

Use WHERE clause to uniquely specify the row you want to delete.

 

DELETE * FROM `Queue` ORDER BY `Time` LIMIT 0 , 1

That doesn't work, how can i make that work?

 

bizmagic, it will just remove the top row -person at top of queue... I don't want to hassle the cron job with more code if there is a way to do this (delete row) without code, so is there?

 

Try LIMIT 1 instead of LIMIT 0,1.

 

Fixed, thanks alot -Silly 0,1

 

Ha ha...no problem.

 

DELETE FROM `Queue` WHERE primid=somevalue

note: primid should be primary key and somevalue should be the first id.

 

DELETE * FROM `Queue` ORDER BY `Time` ORDER BY `test2` LIMIT 1;