home / fixtures / compound_three_primary_keys

compound_three_primary_keys

26 rows where pk1 = "b" and pk2 = "l"

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

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