Thank you, I how do I pipe in Windows? I have not had any luck using the pipe command. I do want to make sure it is going in order so that I have a way of tracking where it was if it fails. At first it is just going to a TXT file and then I use .import to apply it to the necessary tables. The .dump command copies everything including the table not just the entries in the table.
Thank you, Kirk. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kees Nuyt Sent: Wednesday, December 08, 2010 12:38 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Selecting a group of entries based on RowID. On Tue, 7 Dec 2010 10:44:31 -0800, Kirk Clemons <k...@chiefarchitect.com> wrote: >I would like to select each row in order from a table without getting the >table information as well. >This way I can insert them into another database with the same tables. >How would I do this? $ sqlite3 mydb.db3 ".dump TABLENAME"|grep -e ^INSERT and pipe the result into the database command line tool of the other database. Your requirement "in order" is not satisfied this way, but since you insert the data into another database the order is not important. -- ( 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