Hi,
I need to perform a query which deletes the selected results from the table,
like SELECT * from data where name='harsh' (here i want something to delete it as well)
if its possible with single query...
thanks for help..:)
It sounds as though you really want something more like this:
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]