Re: [sqlite] Import skip first line

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/06/13 07:26, Bart Smissaert wrote: > Is there a way to use the other features, but not this one, say if the > table is already there? The autoimport code is one function so you get all of it, or none of it. The same is true of the import code

Re: [sqlite] Import skip first line

Thanks, will have a look at that as well. In my particular situation though I wouldn't want the auto data-type detection as that will slow things down and I will always know what the table fields affinities should be. Is there a way to use the other features, but not this one, say if the table is

Re: [sqlite] Import skip first line

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 31/05/13 05:34, Bart Smissaert wrote: > Importing a. csv file via the. import command of sqlite3.exe. As the > first line holds the field names I want to skip that. There is no > problem achieving this in code, but could I do this purely via

Re: [sqlite] Import skip first line

Bart Smissaert wrote: That modified version sounds useful. Could you mail it? The source as modified is at http://www.filedropper.com/sqlite3modifiedshell . This includes a readline library that works on Win32. The SQLite library source is omitted for space. The shell incorporates the

Re: [sqlite] Import skip first line

That modified version sounds useful. Could you mail it? RBS On May 31, 2013 6:14 PM, "Larry Brasfield" wrote: > Bart Smissaert wrote: > >> Importing a. csv file via the. import command of sqlite3.exe. >> As the first line holds the field names I want to skip that. >>

Re: [sqlite] Import skip first line

Bart Smissaert wrote: Importing a. csv file via the. import command of sqlite3.exe. As the first line holds the field names I want to skip that. There is no problem achieving this in code, but could I do this purely via sqlite3 commands? You could do it easily with a temporary table having an

[sqlite] Import skip first line

Importing a. csv file via the. import command of sqlite3.exe. As the first line holds the field names I want to skip that. There is no problem achieving this in code, but could I do this purely via sqlite3 commands? RBS ___ sqlite-users mailing list