compound_three_primary_keys

12 rows where pk1 = "b" and pk3 = "x"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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