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