Thursday, December 20, 2012

updating two tables in a single query in mysql

updating two tables in a single query in mysql



UPDATE  tb1 , tb2  SET  tb1.name= 'new name', tb2.name = 'tb2 name'   WHERE   tb1.id = '1'  AND  tb2.id = '5'



No comments:

Post a Comment

If you Satisfied , Please Leave a comment