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