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 |
| b,l,a | b | l | a | b-l-a |
| b,l,b | b | l | b | b-l-b |
| b,l,c | b | l | c | b-l-c |
| b,l,d | b | l | d | b-l-d |
| b,l,e | b | l | e | b-l-e |
| b,l,f | b | l | f | b-l-f |
| b,l,g | b | l | g | b-l-g |
| b,l,h | b | l | h | b-l-h |
| b,l,i | b | l | i | b-l-i |
| b,l,j | b | l | j | b-l-j |
| b,l,k | b | l | k | b-l-k |
| b,l,l | b | l | l | b-l-l |
| b,l,m | b | l | m | b-l-m |
| b,l,n | b | l | n | b-l-n |
| b,l,o | b | l | o | b-l-o |
| b,l,p | b | l | p | b-l-p |
| b,l,q | b | l | q | b-l-q |
| b,l,r | b | l | r | b-l-r |
| b,l,s | b | l | s | b-l-s |
| b,l,t | b | l | t | b-l-t |
| b,l,u | b | l | u | b-l-u |
| b,l,v | b | l | v | b-l-v |
| b,l,w | b | l | w | b-l-w |
| b,l,x | b | l | x | b-l-x |
| b,l,y | b | l | y | b-l-y |
| b,l,z | b | l | z | b-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);