On Fri, 18 Jul 2014 21:56:31 +0100, Rui Fernandes <[email protected]> wrote:
> I already know how to import a csv file, and save it in SQLite format. > But how can I define the time of variable in the fields since it assumes > all of them are TEXT? > > Where can I find this information? And do I create this before the input - > how? To do that, you have to create the table beforehand, with the correct column definitions. After that, .import the file, without the header line in this case. http://www.sqlite.org/mark/cli.html?For+the+second+case*table.#csv >Kind regards, > >Miguel Fernandes -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
