compound_three_primary_keys

26 rows where pk2 = "p"

✎ View and edit SQL

This data as json, CSV (advanced)

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