Skip to content

Instantly share code, notes, and snippets.

@addorange
Created May 31, 2013 08:01
Show Gist options
  • Save addorange/5683521 to your computer and use it in GitHub Desktop.
Save addorange/5683521 to your computer and use it in GitHub Desktop.
MySQL - Copy data from one table to another, even if they have different structures
INSERT INTO `s_campaigns_mailaddresses` (`customer`,`email`)
SELECT '1', `email`
FROM `s_user`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment