Guides

Step-by-step answers to data tasks developers run into every week, with the exact commands for each database and the gotchas that usually cost an afternoon.

• How to import a CSV file into MySQL, PostgreSQL, SQL Server and SQLite

  LOAD DATA, \copy, BULK INSERT and .import with the permission gotchas for each, plus what to do when you can't use a bulk loader at all.