home / fixtures

compound_three_primary_keys

26 rows where pk2 = "q"

✎ View and edit SQL

This data as json, CSV (advanced)

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