Re: Insert if not exists MYSQL 5.5.24

[Colleen Boye]

So you want to insert this line iff a line with cod=1 doesn't already exist?

If cod is your primary key, just use INSERT IGNORE. Then it will try to insert the line, and if a line with the same primary key already exists, it won't insert it.

If cod isn't your primary key...well, I'd seriously think about making it a primary key, since you're basically using it as one already (ie, creating records that should have distinct values in that field).