This data as json, CSV (advanced)
| Link | pk1 | pk2 | pk3 | content |
|---|---|---|---|---|
| b,a,w | b | a | w | b-a-w |
| b,b,w | b | b | w | b-b-w |
| b,c,w | b | c | w | b-c-w |
| b,d,w | b | d | w | b-d-w |
| b,e,w | b | e | w | b-e-w |
| b,f,w | b | f | w | b-f-w |
| b,g,w | b | g | w | b-g-w |
| b,h,w | b | h | w | b-h-w |
| b,i,w | b | i | w | b-i-w |
| b,j,w | b | j | w | b-j-w |
| b,k,w | b | k | w | b-k-w |
| b,l,w | b | l | w | b-l-w |
JSON shape: default, array, newline-delimited, object
CREATE TABLE compound_three_primary_keys ( pk1 varchar(30), pk2 varchar(30), pk3 varchar(30), content text, PRIMARY KEY (pk1, pk2, pk3) ); CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);