home / fixtures

compound_three_primary_keys

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

52 rows where pk2 = "l" sorted by content

View and edit SQL

Suggested facets: pk1, pk3

pk2

Link pk1 pk2 pk3 content ▼
a l a a-l-a
a l b a-l-b
a l c a-l-c
a l d a-l-d
a l e a-l-e
a l f a-l-f
a l g a-l-g
a l h a-l-h
a l i a-l-i
a l j a-l-j
a l k a-l-k
a l l a-l-l
a l m a-l-m
a l n a-l-n
a l o a-l-o
a l p a-l-p
a l q a-l-q
a l r a-l-r
a l s a-l-s
a l t a-l-t
a l u a-l-u
a l v a-l-v
a l w a-l-w
a l x a-l-x
a l y a-l-y
a l z a-l-z
b l a b-l-a
b l b b-l-b
b l c b-l-c
b l d b-l-d
b l e b-l-e
b l f b-l-f
b l g b-l-g
b l h b-l-h
b l i b-l-i
b l j b-l-j
b l k b-l-k
b l l b-l-l
b l m b-l-m
b l n b-l-n
b l o b-l-o
b l p b-l-p
b l q b-l-q
b l r b-l-r
b l s b-l-s
b l t b-l-t
b l u b-l-u
b l v b-l-v
b l w b-l-w
b l x b-l-x
b l y b-l-y
b l z b-l-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 5.976ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py