Skip to content

Instantly share code, notes, and snippets.

@mofas

mofas/insertNotExists.sql

Last active August 29, 2015 14:05
Show Gist options
  • Save mofas/3a89072f17664d92d1ae to your computer and use it in GitHub Desktop.
Save mofas/3a89072f17664d92d1ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
insertNotExists.sql
INSERT INTO app (appID, appType, partnerID) SELECT distinct(appID), appType, partnerID FROM performance WHERE appID IN( SELECT distinct(appID) FROM performance AS ip WHERE date='2014-08-13' AND NOT EXISTS (SELECT appID FROM app AS ia WHERE ip.appID = ia.appID) AND ip.appID IS NOT NULL AND ip.appID != '') LIMIT 1000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment