compound_three_primary_keys

26 rows where pk1 = "b" and pk2 = "e"

View and edit SQL

pk2

pk1

Link pk1 pk2 pk3 content
b e a b-e-a
b e b b-e-b
b e c b-e-c
b e d b-e-d
b e e b-e-e
b e f b-e-f
b e g b-e-g
b e h b-e-h
b e i b-e-i
b e j b-e-j
b e k b-e-k
b e l b-e-l
b e m b-e-m
b e n b-e-n
b e o b-e-o
b e p b-e-p
b e q b-e-q
b e r b-e-r
b e s b-e-s
b e t b-e-t
b e u b-e-u
b e v b-e-v
b e w b-e-w
b e x b-e-x
b e y b-e-y
b e z b-e-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)
);
CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);
Powered by Datasette · Query took 7.636ms