home / fixtures

compound_three_primary_keys

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

52 rows where pk2 = "a"

View and edit SQL

Suggested facets: pk3

pk1

pk2

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

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