home / fixtures

compound_three_primary_keys

38 rows where pk3 = "y"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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