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
