Guley/update-multiple-columns

Created September 7, 2023 12:04

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Guley/695580862c551677073c4a9d29570bad.js"></script>
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