home / fixtures / compound_three_primary_keys

compound_three_primary_keys

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

✎ View and edit SQL

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

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