> >thanks for help..:)
It sounds as though you really want something more like this:
DELETE FROM data WHERE name='harsh';
That will only result in deletion,I want it to be displayed and simultaneously deleted.more precisely the effect of following two commands in one
SELECT from data where name='harsh'; DELETE from data where name='harsh';
You can't do it. You'll need to execute both statements.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]