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