How to correct 'datatype mismatch' error while importing the csv file into sqlite table?

user_2436437 0
Viewed 2213

I am trying to import the following data into the sqlite3 table via nodes_corrected.csv file:

id,lat,lon,user,uid,version,changeset,timestamp 26529519,12.9728616,77.6199745,Nagesh_Blr,1765920,34,26587371,2014-11-06 07:56:32.000

I have a schema:

CREATE TABLE nodes (
    id INTEGER PRIMARY KEY NOT NULL,
    lat REAL,
    lon REAL,
    user TEXT,
    uid INTEGER,
    version INTEGER,
    changeset INTEGER,
    timestamp TEXT );

After I use the following code on the terminal:

.mode csv
.import nodes_corrected nodes

I get the following error on terminal:

nodes_corrected:1: INSERT failed: datatype mismatch

Could somebody please help, I am stuck on it for a day?

sqlite sql
0 Answers
Related