home / fixtures

compound_three_primary_keys

26 rows where pk2 = "w"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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 3.863ms