Skip to content

Instantly share code, notes, and snippets.

@lucasmezencio

lucasmezencio/MySQL.UPDATE.SELECT.sql

Created November 19, 2013 22:48
Show Gist options
  • Save lucasmezencio/7553975 to your computer and use it in GitHub Desktop.
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