sqlite> CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) UNIQUE,username varchar(50),password varchar(50)); sqlite> .mode csv sqlite> .import kk.txt webinfo sqlite> select * from webinfo; 0,nytime,gf,a1..7 1,bbc,1982,tbth432 2,oknic,[email protected],bbaa1122 sqlite>
Did you forget to say ".mode csv"? --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of YAN HONG YE > Sent: Monday, 16 July, 2012 01:30 > To: [email protected] > Subject: [sqlite] Error: datatype mismatch > > the table is: > CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) > UNIQUE,userna > me varchar(50),password varchar(50)); > > and the txt file kk.txt is utf8: > 0,nytime,gf,a1..7 > 1,bbc,1982,tbth432 > 2,oknic,[email protected],bbaa1122 > > when I use > " .import kk.txt webinfo" > in cmd line I got the error msg: > Error: datatype mismatch > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
