| 1 |
DROP TABLE IF EXISTS t1; |
| 2 |
CREATE TABLE t1(a INT NOT NULL, b INT) ENGINE = INNODB; |
| 3 |
INSERT INTO t1 VALUES (1,1),(1,2),(1,3),(1,4); |
| 4 |
ALTER TABLE t1 ADD PRIMARY KEY(b), ADD UNIQUE INDEX(a); |
| 5 |
ERROR 23000: Duplicate entry '1' for key 't1.a' |
| 6 |
DROP TABLE t1; |