Re: How to create a uniq index on two non uniq columns

[Peter Brawley]

drop table if exists t;
create table t(i int,j int,k int,primary key(i),unique key(j,k));
insert into t values(1,1,1),(2,1,2),(3,2,1),(4,2,2);
select * from t;
+---+------+------+
| i | j | k |
+---+------+------+
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 1 |
| 4 | 2 | 2 |
+---+------+------+

What is the problem?

PB
http://www.artfulsoftware.com