home / fixtures

compound_three_primary_keys

39 rows where pk3 = "i"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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