home / fixtures

Menu
  • Sign in IndieAuth

compound_three_primary_keys

13 rows where pk1 = "b" and pk2 = "m"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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 · Queries took 5.771ms · About: simonw/datasette-indieauth