Hacker News new | ask | show | jobs
by mkiwala 4651 days ago
The sqlite3 .import command does not handle quoted csv values.

"Doe, John", 1234 Pine St, Springfield

That would be imported as 4 fields, not 3.

1 comments

Used to be true. But recent versions of SQLite fix this.