sqlite3 ".import FILE TABLE ";
can someone clarify:
1) Can I import into a file into a db table where they are more columns in the
db table than in the file to upload?
>From my understanding its a no.
2) In this case the ordering of the columns of the table has to be consistent
with the ordering of the columns in the file that is to be uploaded
>From my understanding its a yes.
3) From a linux box whats the easiest way of backing up the db in perl or
shell?
Can I lock the $sqlitedb first (how?) and then cp $sqlitedb /usr/local/db/backup
Thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
