home / fixtures

compound_three_primary_keys

38 rows where pk3 = "p"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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