compound_three_primary_keys

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

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