This data as json, CSV (advanced)
Link | pk1 | pk2 | pk3 | content |
---|---|---|---|---|
b,a,h | b | a | h | b-a-h |
b,b,h | b | b | h | b-b-h |
b,c,h | b | c | h | b-c-h |
b,d,h | b | d | h | b-d-h |
b,e,h | b | e | h | b-e-h |
b,f,h | b | f | h | b-f-h |
b,g,h | b | g | h | b-g-h |
b,h,h | b | h | h | b-h-h |
b,i,h | b | i | h | b-i-h |
b,j,h | b | j | h | b-j-h |
b,k,h | b | k | h | b-k-h |
b,l,h | b | l | h | b-l-h |
b,m,h | b | m | h | b-m-h |
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);