Mysql syntax for update with inner join - TechRepublic
General discussion
November 8, 2011 at 11:53 AM
cmm8907

Mysql syntax for update with inner join

by cmm8907 . Updated 14 years, 7 months ago

Not sure why this is kicking back syntax errors. Not to familiar with running an update and inner join so any help would be great. Thanks

UPDATE table1 set primaryservicelocation=(’99’)
FROM table2
INNER JOIN table1 ON table2.pid = table1.uid
WHERE randomvalue=’363908′

This discussion is locked

All Comments