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