$@fracasula$

fracasula/mysql_update_join.sql

Created March 12, 2015 14:48

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

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/fracasula/ca39dbd65dbb671cab10.js"></script>
Save fracasula/ca39dbd65dbb671cab10 to your computer and use it in GitHub Desktop.

Download ZIP

Update with Join in MySQL

Raw

mysql_update_join.sql

	UPDATE TABLEA a
	JOIN TABLEB b ON a.join_colA = b.join_colB
	SET a.columnToUpdate = [something]

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