I have a table with an auto_inc
id (primary key).
I am trying to avoid the insertion of duplicate rows.
Example of a duplicate row:
id | field a | field b | field c |
1 4 6 7
2 4 6 7
The key (id
) is not duplicate since it is automatically generated by MySQL, but all other fields are identical.