Thanks! It worked. Thanks a ton, JP
----- Original Message ---- From: Kees Nuyt <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Friday, June 13, 2008 11:50:12 AM Subject: Re: [sqlite] Sqliite Command for appending the data to file On Thu, 12 Jun 2008 10:48:11 -0700 (PDT), you wrote: > 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. On one line: echo ".headers on\n.separator ,\nselect 'myTable' as tablename,* from myTable;" | sqlite3 databasefilename >>dataFile >Thanks in advance, >JP I hope this helps. -- ( Kees Nuyt ) c[_] _______________________________________________ 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
