I got the same problem so i put the output file after the query
Like this
sqlite3 (my path here)AddressBook.sqlitedb
sqlite> .mode csv
sqlite> SELECT ROWID, First, Last, ABMultiValue.value, record_id FROM ABPerson, ABMultiValue WHERE ROWID=record_id;
sqlite> .output (my path here)contacts.csv...