On 7/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"=?ISO-8859-1?Q?Alberto_Sim=F5es?=" <[EMAIL PROTECTED]> wrote:
> Ok, for future reference (drh, please, it would be nice to add this to
> the web site)
That is why we have wiki (http://www.sqlite.org/cvstrac/wiki) so
that you can add
"=?ISO-8859-1?Q?Alberto_Sim=F5es?=" <[EMAIL PROTECTED]> wrote:
> Ok, for future reference (drh, please, it would be nice to add this to
> the web site)
That is why we have wiki (http://www.sqlite.org/cvstrac/wiki) so
that you can add things like this yourself.
I'm busy trying to fix database
On 7/19/07, Veikko Mäkinen <[EMAIL PROTECTED]> wrote:
Alberto Simões wrote:
> Hi
>
> I have a file (big file with 16 000 000 lines) with records like
>
> 2 3 4
> 4 3 2
> 5 4 387
> 5 8 5473
> ...
>
> and I want to import this to an SQLite table.
> Although I can replace all this to INSERT
Ok, for future reference (drh, please, it would be nice to add this to
the web site)
To import:
3 5 6
3 4 6
CREATE TABLE foo (v1,v2,v3);
.separator " "
.import "file.dat" foo
Cheers
Alberto
On 7/19/07, Yusuke ITO <[EMAIL PROTECTED]> wrote:
Hi,
COPY command (like PostgreSQL)
Regarding: "Meanwhile I found an '.import' command on SQLite, but I
can't find a suitable documentation on how it works."
It can be easy to miss page: http://www.sqlite.org/sqlite.html
where this is documented.
Basically, it sounds like you might want to invoke the command line
utility,
Alberto Simões wrote:
Hi
I have a file (big file with 16 000 000 lines) with records like
2 3 4
4 3 2
5 4 387
5 8 5473
...
and I want to import this to an SQLite table.
Although I can replace all this to INSERT commands very easily, I
would like to ask first if there is any faster method.
I
Hi,
COPY command (like PostgreSQL)
http://www.sqlite.org/lang_copy.html
COPY tbl_foo (col1, col2, col3) FROM stdin;
2 3 4
4 3 2
5 4 387
5 8 5473
\.
--
Yusuke ITO
[EMAIL PROTECTED]
On Thu, 19 Jul 2007 13:01:53 +0200
"Sylko Zschiedrich" <[EMAIL
On 7/19/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
Hi
I have a file (big file with 16 000 000 lines) with records like
2 3 4
4 3 2
5 4 387
5 8 5473
...
and I want to import this to an SQLite table.
Although I can replace all this to INSERT commands very easily, I
would like to ask first if
I have a file (big file with 16 000 000 lines) with records like
2 3 4
4 3 2
5 4 387
5 8 5473
...
and I want to import this to an SQLite table.
Although I can replace all this to INSERT commands very easily, I
would like to ask first if there is any faster method.
Meanwhile I found an
9 matches
Mail list logo
