MySQL - How to insert record if not exists to avoid data duplication

While coding an application with MySQL as database, you might come into this situation:You want to insert a new record into a table, if and only if there is no existing record in the table with certain matching fields.The matching field(s) need not has a unique constrain in your table structure design.Your...

By: ppfoong

You're now about to leave Blogged.my to an external website. We are not responsible for the content of external websites. We do not produce them or maintain/update them; we cannot change them and the content can be changed without our knowledge or agreement.

By proceeding to the external website, you agree that all user generated content submitted to our website are the responsibility of the user alone, and should not be understood to be our endorsement of that website or the site's owners (or their content/products/services).

We'll be redirecting you shortly... click here if you don't want to wait.

Registered and logged in users are redirected immediately, why not consider signing up? It's free!