home / fixtures

compound_three_primary_keys

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

39 rows where pk3 = "d"

View and edit SQL

Suggested facets: pk1, pk2

pk3

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

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.048ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py