compound_three_primary_keys

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

✎ View and edit SQL

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

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