need a help in DELETE syntax - MySQL

[piyush]

i want to deleta a row say
DELETE FROM myrow WHERE id=234 ;

but i want to know the details of the deleted row without using any
second statement !! is it possible to write a statement which will
return the details of deleted row !!!

[Sean]

Don't think so.

If "select * from myrow where id = 234; delete from myrow where id = 234"
doesn't work, then I don't think that there's an elegant alternative.

And what's so bad about a second statement.

SA

"piyush" <com> wrote in message
news:googlegroups.com... 

[piyush]

my php server is using remote mysql server so its advantageous to use
minimum number of queries / statements

thanks for reply