SQLite User Forum

.import error
Login

.import error

(1) By anonymous on 2024-03-11 00:17:52 [source]

Steps to reproduce:

$ sqlite3 db1.db
sqlite> create table t1 (a text, b text, c as (a || b));
sqlite> .exit

$ echo 'aaa|bbb' > 1.txt

$ sqlite3 db1.db
sqlite> .import 1.txt t1
Error: table t1 has 2 columns but 3 values were supplied