• 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

Posts Tagged ‘mysql’

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


Posted in tech | Tagged: , , | Leave a Comment »