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