compound_three_primary_keys

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

676 rows where pk1 = "a" sorted by pk3

View and edit SQL

pk1

Link pk1 pk2 pk3 ▼ content
a w d a-w-d
a x d a-x-d
a y d a-y-d
a z d a-z-d
a a e a-a-e
a b e a-b-e
a c e a-c-e
a d e a-d-e
a e e a-e-e
a f e a-f-e
a g e a-g-e
a h e a-h-e
a i e a-i-e
a j e a-j-e
a k e a-k-e
a l e a-l-e
a m e a-m-e
a n e a-n-e
a o e a-o-e
a p e a-p-e
a q e a-q-e
a r e a-r-e
a s e a-s-e
a t e a-t-e
a u e a-u-e
a v e a-v-e
a w e a-w-e
a x e a-x-e
a y e a-y-e
a z e a-z-e
a a f a-a-f
a b f a-b-f
a c f a-c-f
a d f a-d-f
a e f a-e-f
a f f a-f-f
a g f a-g-f
a h f a-h-f
a i f a-i-f
a j f a-j-f
a k f a-k-f
a l f a-l-f
a m f a-m-f
a n f a-n-f
a o f a-o-f
a p f a-p-f
a q f a-q-f
a r f a-r-f
a s f a-s-f
a t f a-t-f
a u f a-u-f
a v f a-v-f
a w f a-w-f
a x f a-x-f
a y f a-y-f
a z f a-z-f
a a g a-a-g
a b g a-b-g
a c g a-c-g
a d g a-d-g
a e g a-e-g
a f g a-f-g
a g g a-g-g
a h g a-h-g
a i g a-i-g
a j g a-j-g
a k g a-k-g
a l g a-l-g
a m g a-m-g
a n g a-n-g
a o g a-o-g
a p g a-p-g
a q g a-q-g
a r g a-r-g
a s g a-s-g
a t g a-t-g
a u g a-u-g
a v g a-v-g
a w g a-w-g
a x g a-x-g
a y g a-y-g
a z g a-z-g
a a h a-a-h
a b h a-b-h
a c h a-c-h
a d h a-d-h
a e h a-e-h
a f h a-f-h
a g h a-g-h
a h h a-h-h
a i h a-i-h
a j h a-j-h
a k h a-k-h
a l h a-l-h
a m h a-m-h
a n h a-n-h
a o h a-o-h
a p h a-p-h
a q h a-q-h
a r h a-r-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 7.733ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo