home / fixtures

compound_three_primary_keys

39 rows where pk3 = "h"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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.397ms