On 2012-05-01 20:41, Baruch Burstein wrote: > It is already wrapped in a transaction. > I seem to remember seeing somewhere that the .import command doesn't > understand escaping, e.g. > > "one","two,three" > > will get imported as > > "one" | "two | three" > > (the quotes are part of the data, and the second column was split into two > by the comma) > Just a point to be aware of. That could be mitigated by writing a small script that "converts" the CSV contents line-wise to SQL-statements, right?
// Oliver PS: re-sending after the mailing lists chokes on my message with S/MIME signature. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
