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 = "x"

✎ View and edit SQL

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

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

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