CSV
Importing a CSV Into MySQL With a Header Row and Odd Quotes
Skip a header with IGNORE 1 LINES, then handle doubled quotes, backslashes, embedded newlines and Windows line endings that LOAD DATA treats differently.
7 min read
Topic
Data Wrangling
Take messy CSV, JSON and spreadsheets and land them in tables without losing a row or a character on the way.
CSV
MySQL LOAD DATA LOCAL INFILE Disabled and How to Enable It
Two switches control LOAD DATA LOCAL, one on the server and one on the client, each failing with its own error code. Enable both safely and know the risk.
6 min read
CSV
MySQL Error 1290 The Server Is Running With secure file priv
Error 1290 blocks LOAD DATA INFILE and INTO OUTFILE outside one directory. Find the allowed path, move the file there, or switch to LOCAL and know the cost.
6 min read
CSV
Using LOAD DATA INFILE to Import a CSV Into MySQL Tables
Every clause of LOAD DATA INFILE that matters for a CSV, from the tab default to NULL handling, with the output of each variant on MySQL 8.4.
7 min read
Editor's pick
CSVGuide
How to Import a CSV File Into MySQL the Reliable Way
LOAD DATA LOCAL turns bad values into warnings and still reports success. Import a CSV into MySQL safely, with a script that checks before it swaps.
23 min read
CSV
Loading a CSV From a URL Into PostgreSQL Without Saving It
Stream a CSV from a web address straight into COPY with curl. See what a 404 and a cut off download do to a plain pipe, and the guards that fix it.
8 min read
CSV
Loading a Gzipped CSV Into PostgreSQL Without Unpacking It
Stream a gzipped CSV into PostgreSQL with gunzip and COPY, time it against unpacking first, and see what a truncated archive does to a pipe.
8 min read
CSV
Skipping Bad Rows During a PostgreSQL CSV Import Safely
PostgreSQL 17 can skip rows with bad values during COPY. See ON_ERROR, REJECT_LIMIT and verbose logging in action, and the errors they do not cover.
7 min read
CSV
Handling NULL and Empty Strings in PostgreSQL CSV Imports
PostgreSQL loads an unquoted empty field as NULL and a quoted one as an empty string. See the options that change that and the integer error one causes.
8 min read
CSV
Loading a CSV Into a Staging Table Then Cleaning It in SQL
Load a messy CSV as text first, then convert it with SQL. Build a three format date parser, a reject table with reasons, and the typed insert.
8 min read
CSV
Importing Only Some CSV Columns Into a PostgreSQL Table
COPY cannot skip file columns. Compare two ways to load three of eight columns of a 2,000,000 row CSV, with timings, and see why cut breaks on quotes.
6 min read
CSV
PostgreSQL Invalid Byte Sequence for UTF8 in a CSV Import
COPY stops with an invalid byte sequence error when a CSV is Latin 1. Fix it with the ENCODING option or client_encoding, and avoid the SQL_ASCII trap.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.