Re: [sqlite] Sqliite Command for appending the data to file
Thanks! It worked. Thanks a ton, JP - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: General Discussion of SQLite Database 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
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] Sqliite Command for appending the data to file
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