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

Reply via email to