Skip to content

Instantly share code, notes, and snippets.

@oak-tree

oak-tree/update between mysql table

Created April 29, 2014 20:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oak-tree/bed7886143a124839850 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oak-tree/bed7886143a124839850 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update between mysql table
based on http://stackoverflow.com/a/19346375/1211174
UPDATE `reports` r
INNER JOIN
`reportstemp` as t
ON
`r`.`REPORT_ID`= `t`.`REPORT_ID`
SET
`r`.`LAST_MODIFIED` = `t`.`LAST_MODIFIED`,
`r`.`modifier_id` = `t`.`modifier_id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment