Felipe Lopes wrote:

I am trying to import a csv file (ip-to-country to be especific) to a table on sqlite db.



Version 2.8:

   COPY <tablename> FROM '<filename>' USING DELIMITERS ',';

Version 3.0:

   .mode csv
   .import <filename> <tablename>



--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565



Reply via email to