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

✖
✖
✖

✎ View and edit SQL

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

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

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