home / fixtures

compound_three_primary_keys

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

39 rows where pk3 = "m"

View and edit SQL

Suggested facets: pk1, pk2

pk3

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

Advanced export

JSON shape: default, array, 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 4.076ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py