compound_three_primary_keys

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

26 rows where pk1 = "a" and pk3 = "v"

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

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

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);