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