-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 21/02/13 02:34, Gert Van Assche wrote:
> Does anyone see something obvious I'm doing wrong?
There is no need to bash the SQLite shell into what you are trying to do.
You can write your own code to read your file and insert each row into
the database.
Another option is to convert the data file into SQL commands. Place
"BEGIN;" at the beginning of the file, and "END;" at the end of the file,
and then precede each line with "INSERT INTO Source VALUES('", double up
any single quotes in the line, and append "';". (That is essentially what
the .import command is doing behind the scenes, but it tries a lot harder
to find separators, count/enforce number of columns, deal with end of line
etc.)
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAlEl/9kACgkQmOOfHg372QSx2gCg49DGhrLuSIelDYMn0RAPe+GH
EHkAoJgzYZmyVEUGUcBNbWDxq90s8a5q
=koQD
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
