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
