Update one table using data from another

Published: | by Julian Knight Reading time ~1 min.
📖 Posts | 📎 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