table_with_compound_pk
7 rows where pk1 = 3
This data as json, CSV (advanced)
Link | pk1 | pk2 | name |
---|---|---|---|
3,1 | 3 | 1 | Row 3 1 |
3,2 | 3 | 2 | Row 3 2 |
3,3 | 3 | 3 | Row 3 3 |
3,4 | 3 | 4 | Row 3 4 |
3,5 | 3 | 5 | Row 3 5 |
3,6 | 3 | 6 | Row 3 6 |
3,7 | 3 | 7 | Row 3 7 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [table_with_compound_pk] ( [pk1] INTEGER, [pk2] INTEGER, [name] TEXT, PRIMARY KEY ([pk1], [pk2]) );