home / fixtures

compound_three_primary_keys

39 rows where pk3 = "l"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1

pk2 26 ✖

  • a 2
  • b 2
  • c 2
  • d 2
  • e 2
  • f 2
  • g 2
  • h 2
  • i 2
  • j 2
  • k 2
  • l 2
  • m 2
  • n 1
  • o 1
  • p 1
  • q 1
  • r 1
  • s 1
  • t 1
  • u 1
  • v 1
  • w 1
  • x 1
  • y 1
  • z 1

pk3 1 ✖

  • l · 39 ✖
Link pk1 pk2 pk3 content
a,a,l a a l a-a-l
a,b,l a b l a-b-l
a,c,l a c l a-c-l
a,d,l a d l a-d-l
a,e,l a e l a-e-l
a,f,l a f l a-f-l
a,g,l a g l a-g-l
a,h,l a h l a-h-l
a,i,l a i l a-i-l
a,j,l a j l a-j-l
a,k,l a k l a-k-l
a,l,l a l l a-l-l
a,m,l a m l a-m-l
a,n,l a n l a-n-l
a,o,l a o l a-o-l
a,p,l a p l a-p-l
a,q,l a q l a-q-l
a,r,l a r l a-r-l
a,s,l a s l a-s-l
a,t,l a t l a-t-l
a,u,l a u l a-u-l
a,v,l a v l a-v-l
a,w,l a w l a-w-l
a,x,l a x l a-x-l
a,y,l a y l a-y-l
a,z,l a z l a-z-l
b,a,l b a l b-a-l
b,b,l b b l b-b-l
b,c,l b c l b-c-l
b,d,l b d l b-d-l
b,e,l b e l b-e-l
b,f,l b f l b-f-l
b,g,l b g l b-g-l
b,h,l b h l b-h-l
b,i,l b i l b-i-l
b,j,l b j l b-j-l
b,k,l b k l b-k-l
b,l,l b l l b-l-l
b,m,l b m l b-m-l

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);
Powered by Datasette · Queries took 7.416ms