compound_three_primary_keys

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

View and edit SQL

pk3

pk1

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

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