subject:"\[sqlite\] import txt file to sqlite"

Re: [sqlite] import txt file to sqlite

2012-03-12 Thread Simon Davies

On 12 March 2012 08:35, YAN HONG YE wrote: > I wanna import a text file to sqlite db, this follow code is right? > char *zErrMsg = 0; > sqlite3 *db; > > rc=sqlite3_open("foods.db",&db); > sqlite3_exec(db, "CREATE TABLE contact (fliename varchar(128) UNIQUE, > fzip blob

[sqlite] import txt file to sqlite

2012-03-12 Thread YAN HONG YE

I wanna import a text file to sqlite db, this follow code is right? char *zErrMsg = 0; sqlite3 *db; rc=sqlite3_open("foods.db",&db); sqlite3_exec(db, "CREATE TABLE contact (fliename varchar(128) UNIQUE, fzip blob, ntest int, ntest1 int);", 0, 0, &zErrMsg);