• Categories

  • your are stumbler#

    • 26,496
  • Author

  • Recent comments:

    over at this website on Interesting read about Interne…
    Gmail Inbox Tabs and… on Malkovich Bias
    guptaradhesh on Yahoo acquires Tumblr! Great…
  • Advertisements

Insert only if not exists – mysql

Posted by guptaradhesh on April 3, 2014



insert into mytable
(my_string, created_at, removed, flag)
SELECT ‘this string should be unique’,curdate(), 0, ‘new’ FROM temp
Where not exists
(select * from mytable where my_string = ‘this string should be unique’);

// make sure there is no parenthesis in select
// it seems, using a temp table is a requirement


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: