syn-arch/change mass.sql

Created January 5, 2022 06:58

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/syn-arch/3b60314f2780ce9b9398e5ae726f3278.js"></script>
Save syn-arch/3b60314f2780ce9b9398e5ae726f3278 to your computer and use it in GitHub Desktop.

Download ZIP

mysql update column with value from another table

Raw

change mass.sql

	UPDATE tableB
	INNER JOIN tableA ON tableB.name = tableA.name
	SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
	WHERE tableA.name = 'Joe'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment