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