How to do Conditional Inserts in MySQL (INSERT … WHERE NOT EXISTS)

by Jonathan on 11th Aug 2009 in Development, MySQL

At some point or other everyone needs to perform a conditional INSERT; one that is only executed after checking if the data is already in the database – so here’s how.