home / fixtures

compound_three_primary_keys

38 rows where pk3 = "q"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

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

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