Skip to content

Instantly share code, notes, and snippets.

@verschuur
Created May 1, 2020 14:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save verschuur/d55d1f13fb01b1a64a42d07208a72fa3 to your computer and use it in GitHub Desktop.
Save verschuur/d55d1f13fb01b1a64a42d07208a72fa3 to your computer and use it in GitHub Desktop.
# Copy field data from one table to another
UPDATE target_table
INNER JOIN source_table USING (matching_key_field)
SET target_table.<field> = source_table.<field>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment