We can use these options to prevent duplicate records in MySQL table:
- Primary Key: We can define a Primary key in a table. While entering data if there is already a record present with same Primary key, then duplicate record will be rejected.
- Unique Index: We can also create a Unique Index on a column in a table. While inserting new data, if we use duplicate data then Unique index will throw error.