home / fixtures

compound_three_primary_keys

38 rows where pk3 = "z"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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