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