[sqlite] import txt file to sqlite

[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);
        sqlite3_exec(db, " .separator ',';", 0, 0, &zErrMsg);
        sqlite3_exec(db, " .import e:/contact.txt contact", 0, 0, &zErrMsg);

thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users