MySQL: How to delete/update from a table with subqurying from same table

Thursday, January 28, 2010


   UPDATE customer_address SET default_address =1 WHERE address_id = ( 
   SELECT MIN(address_id) FROM (SELECT * FROM customer_address) AS temp
   WHERE customer_id =5 )

Posted by Posted by WL at 3:21 PM
Categories:
 

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)
 
>