table_with_compound_pk
7 rows where pk1 = 2
This data as json, CSV (advanced)
Link | pk1 | pk2 | name |
---|---|---|---|
2,1 | 2 | 1 | Row 2 1 |
2,2 | 2 | 2 | Row 2 2 |
2,3 | 2 | 3 | Row 2 3 |
2,4 | 2 | 4 | Row 2 4 |
2,5 | 2 | 5 | Row 2 5 |
2,6 | 2 | 6 | Row 2 6 |
2,7 | 2 | 7 | Row 2 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]) );