home / fixtures

compound_three_primary_keys

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

38 rows where pk3 = "y"

View and edit SQL

Suggested facets: pk1, pk2

pk3

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

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