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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to