home / fixtures

compound_three_primary_keys

52 rows where pk2 = "a"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk3

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