On 13 Mar 2012, at 2:42am, YAN HONG YE <yanhong...@mpsa.com> wrote: > C:\sqlite\lib>sqlite3 foods.db ".separator ',' " ".import dzhhkmysql.txt dzh" > sqlite3: Error: too many options: ".import dzhhkmysql.txt dzh" > Use -help for a list of options.
You cannot just type lots of commands on the line you use to start the sqlite3 program. And I think you are using the wrong quotes. Please take a look at the end of this page for some good examples: <http://www.sqlite.org/sqlite.html> If you need this just to run once, just type the commands yourself. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users