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 !!!

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" <piyush.plaban (AT) gmail (DOT) com> wrote

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

thanks for reply