compound_three_primary_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

325 rows where pk1 = "b" sorted by pk3

View and edit SQL

Suggested facets: pk2, pk3

pk1

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

Next page

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 14.227ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo