compound_three_primary_keys

52 rows where pk2 = "b"

descending

Link	pk1	pk2	pk3	content
a,b,a	a	b	a	a-b-a
a,b,b	a	b	b	a-b-b
a,b,c	a	b	c	a-b-c
a,b,d	a	b	d	a-b-d
a,b,e	a	b	e	a-b-e
a,b,f	a	b	f	a-b-f
a,b,g	a	b	g	a-b-g
a,b,h	a	b	h	a-b-h
a,b,i	a	b	i	a-b-i
a,b,j	a	b	j	a-b-j
a,b,k	a	b	k	a-b-k
a,b,l	a	b	l	a-b-l
a,b,m	a	b	m	a-b-m
a,b,n	a	b	n	a-b-n
a,b,o	a	b	o	a-b-o
a,b,p	a	b	p	a-b-p
a,b,q	a	b	q	a-b-q
a,b,r	a	b	r	a-b-r
a,b,s	a	b	s	a-b-s
a,b,t	a	b	t	a-b-t
a,b,u	a	b	u	a-b-u
a,b,v	a	b	v	a-b-v
a,b,w	a	b	w	a-b-w
a,b,x	a	b	x	a-b-x
a,b,y	a	b	y	a-b-y
a,b,z	a	b	z	a-b-z
b,b,a	b	b	a	b-b-a
b,b,b	b	b	b	b-b-b
b,b,c	b	b	c	b-b-c
b,b,d	b	b	d	b-b-d
b,b,e	b	b	e	b-b-e
b,b,f	b	b	f	b-b-f
b,b,g	b	b	g	b-b-g
b,b,h	b	b	h	b-b-h
b,b,i	b	b	i	b-b-i
b,b,j	b	b	j	b-b-j
b,b,k	b	b	k	b-b-k
b,b,l	b	b	l	b-b-l
b,b,m	b	b	m	b-b-m
b,b,n	b	b	n	b-b-n
b,b,o	b	b	o	b-b-o
b,b,p	b	b	p	b-b-p
b,b,q	b	b	q	b-b-q
b,b,r	b	b	r	b-b-r
b,b,s	b	b	s	b-b-s
b,b,t	b	b	t	b-b-t
b,b,u	b	b	u	b-b-u
b,b,v	b	b	v	b-b-v
b,b,w	b	b	w	b-b-w
b,b,x	b	b	x	b-b-x
b,b,y	b	b	y	b-b-y
b,b,z	b	b	z	b-b-z

Advanced export

JSON shape: default, array, newline-delimited, object

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);