compound_three_primary_keys

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

325 rows where pk1 = "b" sorted by pk2

View and edit SQL

pk1

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

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