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