lucasmezencio/MySQL.UPDATE.SELECT.sql

Created November 19, 2013 22:48

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/lucasmezencio/7553975.js"></script>
Save lucasmezencio/7553975 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL UPDATE SELECT

Raw

MySQL.UPDATE.SELECT.sql

	UPDATE tableA AS A
	LEFT JOIN tableB AS B on (A.name_a = B.name_b)
	SET
	A.update_date = B.insert_date

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