home / fixtures

compound_three_primary_keys

39 rows where pk3 = "k"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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