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