i like sqlite so far. my data is utf8 and has all the nightmarish junk chars in it, (quotes,!,line_feeds, CR so on.), currently i use mysql and i load data from a file I painstakingly prepare using:
load data local infile '/tmp/p.data' into table tableone fields terminated by "^^^--&&&" LINES TERMINATED BY '\n' (columna,columnb,columnc,columnd); What's the equivalent I can use in sqlite(3), so that I can import the file into my db ? I shud be able to specify FS of "^^^--&&&" many thx in advance. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
