How to prevent INSERT on duplicate rows with 30 fields
I have a MySQL table with about 30 fields.
I am inserting new data, and want to be sure that there are no duplicate rows.
A duplicate row would be one with ALL the 30 fields (except the auto-increment index) exactly the same.
How do I do that efficiently?
Many thanks...
Christian
Subject
Written By
Posted
How to prevent INSERT on duplicate rows with 30 fields
July 07, 2005 07:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.