mysql multiple update query

thava · November 30th, 2009, 02:11 AM

UPDATE Table1
SET col6 = t2.col1
FROM Table1 t1
LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5)

The above query not working pls. correct me.

Thanks,
thava

iamrakesh22 · November 30th, 2009, 10:14 AM

First UPDATE query doesn't has FROM clause.
Second even you want to write a SELECT in SET clause query wont execute. Because you can not give target table 'Table1' in the SELECT.

99developer · July 19th, 2011, 08:42 AM

Code:

UPDATE Table1
SET col6 = t2.col1
FROM Table1 t1
LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5)

you can do this thing like this..

Code:


UPDATE Table1 LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5)
SET col6 = t2.col1

99developer · July 19th, 2011, 08:46 AM

Code:

UPDATE Table1
SET col6 = t2.col1
FROM Table1 t1
LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5)

you can do this thing like this..

Code:


UPDATE Table1 LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5)
SET col6 = t2.col1

another interting that i found about update is here..

http://developer99.blogspot.com/2011...l-queries.html