..MindWrite..

Posts Tagged ‘mysql’

Insert only if not exists – mysql

Posted by guptaradhesh on April 3, 2014

 

Example:

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 »