compound_three_primary_keys

13 rows where pk1 = "b" and pk3 = "c"

✎ View and edit SQL

This data as json, CSV (advanced)

Link pk1 pk2 pk3 content
b,a,c b a c b-a-c
b,b,c b b c b-b-c
b,c,c b c c b-c-c
b,d,c b d c b-d-c
b,e,c b e c b-e-c
b,f,c b f c b-f-c
b,g,c b g c b-g-c
b,h,c b h c b-h-c
b,i,c b i c b-i-c
b,j,c b j c b-j-c
b,k,c b k c b-k-c
b,l,c b l c b-l-c
b,m,c b m c b-m-c

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