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]) );