Skip to content

Instantly share code, notes, and snippets.

@BenjaminLu
Created January 20, 2016 11:42
Show Gist options
  • Save BenjaminLu/cb71618f37171ea1c258 to your computer and use it in GitHub Desktop.
Save BenjaminLu/cb71618f37171ea1c258 to your computer and use it in GitHub Desktop.
INSERT INTO `copy_db_broker`.`order` (
SELECT *
FROM `original_db`.`order`
WHERE `original_db`.`order`.`id` NOT IN (
SELECT `id`
FROM `copy_db_broker`.`order`
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment