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