Kees Nuyt wrote: > > On Fri, 21 Nov 2008 12:05:51 -0800 (PST), TheOnclejuna > <[EMAIL PROTECTED]> wrote in General Discussion of > SQLite Database <sqlite-users@sqlite.org>: > >> >>Hello to everybody, >> >>I'm working few time with SQLite, and can't solve one problem. >> >>I have a script file with this commands: >> >>-------------- script.txt -------------- >>create table temp (title varchar(100), description varchar(200)); >>.separator ; >>.import ./file.txt temp >>update article set company = (select company from temp where temp.title = >>article.title); >>update article set description = (select description from temp where >>temp.title = article.title); >>drop table temp; >>.exit >>-------------- script.txt -------------- >> >>And I run the script with this command in a batch file. >> >>sqlite3 -init script.txt mydb.db3 >> >>The script run very well, but don't close SQLite >>and the batch can't continue. >>I have used .quit .exit .q but don't work and can't find >>an answer on an internet search. > > Try like this: > > sqlite3 mydb.db3 <script.txt > > >>Best regards. >> >>Juan M. Perez > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
Maybe has been easy for you, but has been a enormous help for me. Thousands of thanks Kees. Juan M. Perez -- View this message in context: http://www.nabble.com/Closing-SQLite3-from-script-tp20628648p20631474.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
