This data as json, CSV (advanced)
Link | pk1 | pk2 | pk3 | content |
---|---|---|---|---|
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);