Posts Tagged ‘insert unique’

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 »