SQLite Forum

csv import without header row
Login
Study this session scrape:

```
sqlite> create table Pets (name text, species text);
sqlite> insert into Pets values('Fido', 'dog');
sqlite> insert into Pets values('Fluffy', 'cat');
sqlite> insert into Pets values('Hiss', 'serpent');
sqlite> .mode csv
sqlite> .header on
sqlite> .once pets.csv
sqlite> select * from Pets;
sqlite> create table Beasts (name text, species text);
sqlite> .import --csv --skip 1 pets.csv Beasts
sqlite> select * from Beasts;
name,species
Fido,dog
Fluffy,cat
Hiss,serpent
sqlite>
```