Question

In MySQL given a table and an index:

CREATE table table_1 (col1 int, col2 int);
create UNIQUE INDEX index_1_2 on table_1 (col1, col2);

We start filling the table with data executing following queries one after another, top to bottom. Select all queries that will execute correctly.

Cosmo · Accepted Answer

It is obvious that fifth query will fail because of UNIQUE constraint violation.
What is not obvious though is that forth query will be executed correctly. The thing is that UNIQUE constraint allows multiple NULL values to be inserted.

Cosmo · Accepted Answer

INSERT INTO table_1 VALUES (1, 2);

Cosmo · Accepted Answer

INSERT INTO table_1 VALUES (NULL, 1);

Cosmo · Accepted Answer

INSERT INTO table_1 VALUES (NULL, NULL);

Cosmo · Accepted Answer

INSERT INTO table_1 VALUES (1, NULL);

Follow CodeGalaxy

Mobile Beta