Fastest Web Hosting

how do i multiple table updates simultaneously

0 votes
asked Nov 11, 2016 in Mysql by rajatinsa (3,350 points)

i want to update multiple column of multiple table in one query...please provide solutions

1 Answer

0 votes
answered Nov 11, 2016 by Manoj Insan (1,600 points)

UPDATE table1, table2 SET table1.col1='value',table2='value' where table1.column != "" and table1.col_id=table2.col_id

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's