Or, better yet
.header n
where n=0 <--no header
n>0 <-- number of header lines
If .header is not specified then it defaults to zero so breaking
backwards is not a concern.
On 3/21/2019 19:04, Shawn Wagner wrote:
I thought about suggesting that, but I can see it breaking backwards
compatibility with existing scripts. I set .header on in my ~/.sqliterc for
example, and have things that don't change it before importing csv files
and would thus miss a row.
(I also have a handy perl script that does all this stuff and more, but
it's nice to keep dependencies to a minimum.)
On Thu, Mar 21, 2019 at 6:48 PM D Burgess <dburges...@gmail.com> wrote:
Agree with all that.
A way to skip a header row when the table exists would be useful.
How about
.header on/off
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
