Clemens Ladisch wrote: > Simon Slavin wrote: >> On 19 Oct 2017, at 7:38pm, Clemens Ladisch wrote: >>> the .import command does not work (and can show misleading error messages) >>> if the table name contains special characters: >>> >>> sqlite> .import test.csv temp.t >> >> What format is the file "temp.t" in ? UTF-8 ? ASCII ? Some sort of code >> page ? > > The contents of the file do not matter; just use ".once test.csv", "select > 'x';".
Sorry, I misread; "test.csv" is the file name, "temp.t" is the table name. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
