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