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