home / fixtures

compound_three_primary_keys

38 rows where pk3 = "o"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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