compound_three_primary_keys

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

39 rows where pk3 = "g"

View and edit SQL

Suggested facets: pk1, pk2

pk3

Link pk1 pk2 pk3 content
a a g a-a-g
a b g a-b-g
a c g a-c-g
a d g a-d-g
a e g a-e-g
a f g a-f-g
a g g a-g-g
a h g a-h-g
a i g a-i-g
a j g a-j-g
a k g a-k-g
a l g a-l-g
a m g a-m-g
a n g a-n-g
a o g a-o-g
a p g a-p-g
a q g a-q-g
a r g a-r-g
a s g a-s-g
a t g a-t-g
a u g a-u-g
a v g a-v-g
a w g a-w-g
a x g a-x-g
a y g a-y-g
a z g a-z-g
b a g b-a-g
b b g b-b-g
b c g b-c-g
b d g b-d-g
b e g b-e-g
b f g b-f-g
b g g b-g-g
b h g b-h-g
b i g b-i-g
b j g b-j-g
b k g b-k-g
b l g b-l-g
b m g b-m-g

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Query took 18.864ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette