compound_three_primary_keys
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
325 rows where pk1 = "b" sorted by pk3
This data as json, testall, testnone, testresponse, CSV (advanced)
Link | pk1 | pk2 | pk3 ▼ | content |
---|---|---|---|---|
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 |
b,a,i | b | a | i | b-a-i |
b,b,i | b | b | i | b-b-i |
b,c,i | b | c | i | b-c-i |
b,d,i | b | d | i | b-d-i |
b,e,i | b | e | i | b-e-i |
b,f,i | b | f | i | b-f-i |
b,g,i | b | g | i | b-g-i |
b,h,i | b | h | i | b-h-i |
b,i,i | b | i | i | b-i-i |
b,j,i | b | j | i | b-j-i |
b,k,i | b | k | i | b-k-i |
b,l,i | b | l | i | b-l-i |
b,m,i | b | m | i | b-m-i |
b,a,j | b | a | j | b-a-j |
b,b,j | b | b | j | b-b-j |
b,c,j | b | c | j | b-c-j |
b,d,j | b | d | j | b-d-j |
b,e,j | b | e | j | b-e-j |
b,f,j | b | f | j | b-f-j |
b,g,j | b | g | j | b-g-j |
b,h,j | b | h | j | b-h-j |
b,i,j | b | i | j | b-i-j |
b,j,j | b | j | j | b-j-j |
b,k,j | b | k | j | b-k-j |
b,l,j | b | l | j | b-l-j |
b,m,j | b | m | j | b-m-j |
b,a,k | b | a | k | b-a-k |
b,b,k | b | b | k | b-b-k |
b,c,k | b | c | k | b-c-k |
b,d,k | b | d | k | b-d-k |
b,e,k | b | e | k | b-e-k |
b,f,k | b | f | k | b-f-k |
b,g,k | b | g | k | b-g-k |
b,h,k | b | h | k | b-h-k |
b,i,k | b | i | k | b-i-k |
b,j,k | b | j | k | b-j-k |
b,k,k | b | k | k | b-k-k |
b,l,k | b | l | k | b-l-k |
b,m,k | b | m | k | b-m-k |
b,a,l | b | a | l | b-a-l |
b,b,l | b | b | l | b-b-l |
b,c,l | b | c | l | b-c-l |
b,d,l | b | d | l | b-d-l |
b,e,l | b | e | l | b-e-l |
b,f,l | b | f | l | b-f-l |
b,g,l | b | g | l | b-g-l |
b,h,l | b | h | l | b-h-l |
b,i,l | b | i | l | b-i-l |
b,j,l | b | j | l | b-j-l |
b,k,l | b | k | l | b-k-l |
b,l,l | b | l | l | b-l-l |
b,m,l | b | m | l | b-m-l |
b,a,m | b | a | m | b-a-m |
b,b,m | b | b | m | b-b-m |
b,c,m | b | c | m | b-c-m |
b,d,m | b | d | m | b-d-m |
b,e,m | b | e | m | b-e-m |
b,f,m | b | f | m | b-f-m |
b,g,m | b | g | m | b-g-m |
b,h,m | b | h | m | b-h-m |
b,i,m | b | i | m | b-i-m |
b,j,m | b | j | m | b-j-m |
b,k,m | b | k | m | b-k-m |
b,l,m | b | l | m | b-l-m |
b,m,m | b | m | m | b-m-m |
b,a,n | b | a | n | b-a-n |
b,b,n | b | b | n | b-b-n |
b,c,n | b | c | n | b-c-n |
b,d,n | b | d | n | b-d-n |
b,e,n | b | e | n | b-e-n |
b,f,n | b | f | n | b-f-n |
b,g,n | b | g | n | b-g-n |
b,h,n | b | h | n | b-h-n |
b,i,n | b | i | n | b-i-n |
b,j,n | b | j | n | b-j-n |
b,k,n | b | k | n | b-k-n |
b,l,n | b | l | n | b-l-n |
b,a,o | b | a | o | b-a-o |
b,b,o | b | b | o | b-b-o |
b,c,o | b | c | o | b-c-o |
b,d,o | b | d | o | b-d-o |
b,e,o | b | e | o | b-e-o |
b,f,o | b | f | o | b-f-o |
b,g,o | b | g | o | b-g-o |
b,h,o | b | h | o | b-h-o |
b,i,o | b | i | o | b-i-o |
b,j,o | b | j | o | b-j-o |
b,k,o | b | k | o | b-k-o |
b,l,o | b | l | o | b-l-o |
b,a,p | b | a | p | b-a-p |
b,b,p | b | b | p | b-b-p |
b,c,p | b | c | p | b-c-p |
b,d,p | b | d | p | b-d-p |
b,e,p | b | e | p | b-e-p |
b,f,p | b | f | p | b-f-p |
b,g,p | b | g | p | b-g-p |
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);