> >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'; > > > >------------------------------------------------------------------------------ > >harsh > >http://www.cse.iitb.ac.in/~harsh > >------------------------------------------------------------------------------ > > > -- > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]