compound_three_primary_keys

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

26 rows where pk1 = "a" and pk3 = "k"

View and edit SQL

pk3

pk1

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

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