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