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,y...@sohu.com,bbaa1122 sqlite>
Did you forget to say ".mode csv"? --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of YAN HONG YE > Sent: Monday, 16 July, 2012 01:30 > To: sqlite-users@sqlite.org > 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,y...@sohu.com,bbaa1122 > > when I use > " .import kk.txt webinfo" > in cmd line I got the error msg: > Error: datatype mismatch > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users