[sqlite] where did my data go ? Re: Import data into a temporary table

Luuk writes: | sqlite> .import abc.csv temp.test | Error: no such table: temp.test |. . . | Where did my data go (see above)? The above command to the shell results in an attempted prepare of SQL like this, INSERT INTO “temp.text” VALUES … which fails with a “no such table” complaint. If

[sqlite] where did my data go ? Re: Import data into a temporary table

On 7-3-2019 22:45, Eric Tsau wrote: Hi, Is it possible to add the option of importing data into a temporary table? Currently you have to create a temporary table first before importing to it, or having to drop the table afterwards. .import dump.csv temp.table or .import dump.csv attach.table