home / fixtures

compound_three_primary_keys

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

39 rows where pk3 = "l"

View and edit SQL

Suggested facets: pk1, pk2

pk3

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

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