This data as json, CSV (advanced)
| Link | pk1 | pk2 | pk3 | content |
|---|---|---|---|---|
| a,a,q | a | a | q | a-a-q |
| a,b,q | a | b | q | a-b-q |
| a,c,q | a | c | q | a-c-q |
| a,d,q | a | d | q | a-d-q |
| a,e,q | a | e | q | a-e-q |
| a,f,q | a | f | q | a-f-q |
| a,g,q | a | g | q | a-g-q |
| a,h,q | a | h | q | a-h-q |
| a,i,q | a | i | q | a-i-q |
| a,j,q | a | j | q | a-j-q |
| a,k,q | a | k | q | a-k-q |
| a,l,q | a | l | q | a-l-q |
| a,m,q | a | m | q | a-m-q |
| a,n,q | a | n | q | a-n-q |
| a,o,q | a | o | q | a-o-q |
| a,p,q | a | p | q | a-p-q |
| a,q,q | a | q | q | a-q-q |
| a,r,q | a | r | q | a-r-q |
| a,s,q | a | s | q | a-s-q |
| a,t,q | a | t | q | a-t-q |
| a,u,q | a | u | q | a-u-q |
| a,v,q | a | v | q | a-v-q |
| a,w,q | a | w | q | a-w-q |
| a,x,q | a | x | q | a-x-q |
| a,y,q | a | y | q | a-y-q |
| a,z,q | a | z | q | a-z-q |
| b,a,q | b | a | q | b-a-q |
| b,b,q | b | b | q | b-b-q |
| b,c,q | b | c | q | b-c-q |
| b,d,q | b | d | q | b-d-q |
| b,e,q | b | e | q | b-e-q |
| b,f,q | b | f | q | b-f-q |
| b,g,q | b | g | q | b-g-q |
| b,h,q | b | h | q | b-h-q |
| b,i,q | b | i | q | b-i-q |
| b,j,q | b | j | q | b-j-q |
| b,k,q | b | k | q | b-k-q |
| b,l,q | b | l | q | b-l-q |
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);