You might want to save the query result to a file too:
.once out.csv
select * from person, weight where person.ID = weight.ID;
.mode column .once out.csv
select * from person, weight where person.ID = weight.ID;
.mode columnNo comments yet.