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