Skip to content

Instantly share code, notes, and snippets.

@Guley

Guley/update-multiple-columns

Created September 7, 2023 12:04
Show Gist options
  • Save Guley/695580862c551677073c4a9d29570bad to your computer and use it in GitHub Desktop.
Save Guley/695580862c551677073c4a9d29570bad to your computer and use it in GitHub Desktop.
Download ZIP
Update multiple columns in one table based on values in another table in mysql
Raw
update-multiple-columns
UPDATE tableA JOIN tabelB USING (id)
SET tableA.column = tabelB.column
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment