compound_three_primary_keys

12 rows where pk1 = "b" and pk3 = "p"

View and edit SQL

pk3

pk1

Link pk1 pk2 pk3 content
b a p b-a-p
b b p b-b-p
b c p b-c-p
b d p b-d-p
b e p b-e-p
b f p b-f-p
b g p b-g-p
b h p b-h-p
b i p b-i-p
b j p b-j-p
b k p b-k-p
b l p b-l-p

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 11.112ms