home / fixtures / compound_three_primary_keys

compound_three_primary_keys

26 rows where pk1 = "b" and pk2 = "h"

✎ View and edit SQL

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

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

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 1.2ms