This data as json, CSV (advanced)
| Link | pk1 | pk2 | pk3 | content |
|---|---|---|---|---|
| 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);