compound_three_primary_keys

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

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