On Sun, Aug 26, 2012 at 11:30 AM, Udi Karni <uka...@gmail.com> wrote:
> The following scenario happens occasionally. > > At first the import fails on mismatched columns - as if the "end-of-line" > marker is off. > > You run it again right away and everything completes successfully. > > ????????????????? > > Is there some kind of tracing that can be turned on so that when this > happens we can gather some clues? > > As an aside - not a big deal - this is on Windows - the file specifications > in the ".import" and ".read" commands require 2 back slashes in the syntax > - can that be fixed? > > Thanks ! > Perhaps http://www.sqlite.org/uri.html 3.1 The URI Path will help you -- -- -- --Ô¿Ô-- K e V i N > > Z:\>sqlite3 z:\xyz.db3 > SQLite version 3.7.11 2012-03-20 11:35:50 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> pragma page_size=4096; > sqlite> pragma journal_mode=off; > off > sqlite> pragma temp_store=memory; > sqlite> .timer on > sqlite> .separator ',' > sqlite> .read c:\\create_table\\create_table_xyz.sql > CPU Time: user 0.000000 sys 0.000000 > sqlite> .import c:\\data_csv\\xyz.csv xyz > Error: c:\data_csv\xyz.csv line 12: expected 59 columns of data but found > 99 > sqlite> select count (*) from xyz; > 0 > CPU Time: user 0.000000 sys 0.000000 > sqlite> .import c:\\data_csv\\xyz.csv xyz > sqlite> select count (*) from xyz; > 97744059 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users