Unique VS INSERT IGNORE

Question

As you know, unique columns only accept non-repetitive values. Now, I saw a keyword named IGNORE (It is used after INSERT statement).

Well, I read about INSERT IGNORE in the documentation and I figured out its job is exactly what unique does! So, when should I use IGNORE instead of unique column? When it is useful?

`INSERT IGNORE` allows you to ignore warning message when violating a unique constraint. — Tim Biegeleisen, Nov 19 '15 at 07:37
Possible duplicate of ["INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"](http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update) — Rahul Tripathi, Nov 19 '15 at 07:43

score 1 · Accepted Answer · answered Nov 19 '15 at 07:35

1

These two constructs are complimentary. A unique constraint makes sure a column cannot get repetitive values. The ignore keyword in an insert statement allows the insert statement to ignore any errors (such as unique constraint violations) when inserting new rows to a table.

Without the constraint, your insert statement would just create repetitive values in the table. Without the ignore keyword, attempting to insert such values would error out instead of just silently doing nothing.

answered Nov 19 '15 at 07:35

Mureinik

297,002
52
306
350

Well, for hiding the errors when there is a duplicate value, I have to use `IGNORE`. So, I can use both of them, correct? `Unique` to prevent duplicate values, `IGNORE` for hiding errors. Right? – Shafizadeh Nov 19 '15 at 07:39

Unique VS INSERT IGNORE

1 Answers1