It would appear to me that sqlite and sqlite3 are out-of-sync in respect of the handling of tables with strictly numerical table names - please see the following sqlite3 log demonstrating the problem: ------------------------------------------------------------------------------------------------ -- Loading resources from C:\Users\Kinder/.sqliterc SQLite version 3.28.0 2019-04-16 19:49:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .sys type C:\\Users\\Kinder\\.sqliterc .mode columns .headers on sqlite> create table "_666" (c1 TEXT, c2 TEXT); sqlite> create table "666" (c1 TEXT, c2 TEXT); sqlite> .tables 666 _666 sqlite> .mode csv sqlite> .sys type file.csv "A","B" sqlite> .import "file.csv" "_666" sqlite> select * from "_666"; c1,c2 A,B sqlite> .import "file.csv" "666" Error: near "666": syntax error sqlite> ------------------------------------------------------------------------------------------------ Please feel free to contact me if you require additional information. Regards, Alan Kinder _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
