Update one table using data from another

, Updated by Julian Knight Reading time ~ 1 min.
Posts Development Development, MySQL, SQL

If you want to update tbl1 with information from tbl2:

UPDATE tbl1,tbl2
SET tbl1.col1=tbl2.colx
WHERE ...

comments powered by Disqus