compound_three_primary_keys

26 rows where pk1 = "a" and pk3 = "v"

View and edit SQL

pk3

pk1

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

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.155ms