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

✖
✖
✖

✎ View and edit SQL

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

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

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