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