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