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