At 21:40 +0530 6/28/03, harsh wrote:
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]



Reply via email to