Re: CSV import using CLI (header, NULL)
Dominique Devienne <[email protected]> Sat, 29 Feb 2020 14:02:18 +0100
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAFCRh-8H5aro7c9SxDg-DyKpCc97xrOE_aXo2Ax1sKffYc-SGQ@mail.gmail.com> |
On Sat, Feb 29, 2020 at 1:42 PM Shawn Wagner <[email protected]> wrote: > To import a csv file with headers into an existing table, you can use > .import '| tail -n +2 yourfile.csv' yourtable > to skip the header line. On unix. And by shell’ing out to native tools, so not portable. The cli ought to have something built in, if it doesn’t already. > > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users