compound_three_primary_keys

52 rows where pk2 = "i"

descending

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