2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>:
>
> Regarding:
>
> I want to use .import ... but the first line is the variable(fields), so I
> want to ignore it.
> =
>
> Possible option #1:
>
> If it wouldn't violate any database-enforced constraints, why not import t
On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote:
> As I see,many CSV files using \t as separator.
> And SQLite does not use \t,I have to use sed(or other tools) to change
> Tab to |. so My puzzle is why SQLite not support \t?
You can set separator to be anything you want, including \t.
Use this c
> > Have you tried "head" or "tail"?
> do you means the head command of the OS,say linux ?
> Not yet,using "head" or "tail" will be faster than sed?
My guess would be yes, though probably not much.
It should be pretty simple to test.
If it's a very large file you may be limited by your I/O speed,
2006/1/7, Jay Sprenkle <[EMAIL PROTECTED]>:
> Have you tried "head" or "tail"?
do you means the head command of the OS,say linux ?
Not yet,using "head" or "tail" will be faster than sed?
As I see,many CSV files using \t as separator.
And SQLite does not use \t,I have to use sed(or other tools) to
2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>:
>
> Regarding:
>
> I want to use .import ... but the first line is the variable(fields), so I
> want to ignore it.
> =
>
> Possible option #1:
>
> If it wouldn't violate any database-enforced constraints, why not import t
Have you tried "head" or "tail"?
On 1/6/06, ronggui wong <[EMAIL PROTECTED]> wrote:
> I want to use .import to import a data file into SQLite.but the first
> line is the variable(fields),so I want to ignore it.delete the first
> row of the data is one solution,But the data file is large ,and try t
Regarding:
I want to use .import ... but the first line is the variable(fields), so I
want to ignore it.
=
Possible option #1:
If it wouldn't violate any database-enforced constraints, why not import the
entire file, then delete the first row via SQL?
DELETE
7 matches
Mail list logo