3367
MariaDBERRORNotableData ImportHIGH confidence
Invalid ROW SEPARATOR in LOAD DATA
Production Risk
Low — LOAD DATA fails; no rows are imported.
How to reproduce
trigger — this will error
trigger — this will error
LOAD DATA INFILE 'data.txt' INTO TABLE t ROWS SEPARATED BY '';
expected output
ERROR 3367 (HY000): Row separator is invalid.
Fix
Use a valid row separator
Use a valid row separator
LOAD DATA INFILE 'data.txt' INTO TABLE t FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
Why this works
Standard newline-terminated rows avoid the need for a custom row separator.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3367 ER_INVALID_ROW_SEPARATOR
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev