Now i have the problem that the sqlite3.exe has a problem with "ä, ö, ü" in Database filename. :(
It makes a new db called " D�sseldorf " for example and fails then :( Steffen Mangold -------------------------------------------------------------------------------------------------------------- In your words: 1. start "cmd.exe" 2. go to directory with sqlite3.exe 3. type test.sql | sqlite3 test.db3 (Return) Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Steffen Mangold [steffen.mang...@balticsd.de] Sent: Tuesday, November 29, 2011 1:41 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Runfile script over existing Database Thanks for your fast answere and hi michael, > > type myfile.sql | sqlite3 test.db > Pleae don't laught, but I don't get it to run... :( Let me tell what im doing: 1. start "cmd.exe" 2. go to directory with sqlite3.exe 3. > sqlite3.exe (Return) 4. test.sql | "test.db3" The result is only: sqlite> test.sql | "Saalburg 1.BA (2).db3" ...> Steffen Mangold myfile.sql example between the lines: ==================== create table t(a int); insert into t values(1); select * from t; ==================== You could also do echo .read myfile.sql | sqlite3 test.db Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Steffen Mangold [steffen.mang...@balticsd.de] Sent: Tuesday, November 29, 2011 12:46 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Runfile script over existing Database Hi all, i have a question. I have a script with edit a database file (insert and alter some tables). Now I want to run this script agains an existing database file, with the commandline shell. How can I do this in a batch file (windows) I don't understand the ".read" command. Regards Steffen Mangold _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
