home / fixtures

compound_three_primary_keys

26 rows where pk2 = "s"

✎ View and edit SQL

This data as json, CSV (advanced)

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