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