Hi all, I need to dump the data to file in csv format and I have done the following: sqlite> .output dataFile sqlite> .mode csv sqlite> select * from myTable; sqlite>.quit The data is dump to the file correctly but I want to able to 1) append another table to this dataFile 2) Print the tablename and table's column name to this dataFile as well I have read the.help but I couldn't find any command to help me to do these format at all. Please help if you know the way to append the data to the file and print the tablename as well as table's columns name to the file. Thanks in advance, JP
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
