home / fixtures / compound_three_primary_keys

compound_three_primary_keys

26 rows where pk1 = "b" and pk2 = "g"

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

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

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 1.2ms