compound_three_primary_keys

38 rows where pk3 = "v" sorted by pk2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk2

pk1 2 ✖

  • a 26
  • b 12

pk3 1 ✖

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