On Wed, 18 Sep 2013 20:53:31 -0700 (PDT), niubao <niuba...@gmail.com>
wrote:
>Thank you very much Simon, for your detailed and very clear explanation on
>this. I wonder if there is some materials, a tutorial or something, that
>are dedicated to SQLite schema change for beginners?
>
>There seems to be so many things to consider.
In the "Structure" tab of the Firefox "SQLite Manager" add-on, you can
export the schema for a table to a text file [1], then edit the text
file and feed it back into the database with the menu item Database /
Import, or with the sqlite command line tool [2].
[1] can be compared with .dump in the sqlite command line tool,
as in echo .dump | sqlite3 yourdbfile >schemafile.sql
edit schemafile.sql to reflect your modifications
[2] sqlite3 yourdbile <schemafile.sql
Hope this helps
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
