If you need to update one table with information from another table, you can use next query.
UPDATE sourceTable s, destTable d SET d.something = s.something WHERE d.fieldId = s.id |
ServerAdminBlog
Short Circuit…
Short Circuit…
If you need to update one table with information from another table, you can use next query.
UPDATE sourceTable s, destTable d SET d.something = s.something WHERE d.fieldId = s.id |