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