home / fixtures

compound_three_primary_keys

38 rows where pk3 = "s"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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