compound_three_primary_keys

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

✎ View and edit SQL

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

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