Re: LOAD DATA INFILE Syntax Error?

[Barry Galbraith]

The refman here
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
shows the IGNOR clause coming after the LINES TERMINATED BY clause.

LOAD DATA INFILE '/home/djb/Documents/_libre_office/_calc/SchoolsDatabaseExportAsCSVSchoolsTable.csv'
INTO TABLE schools
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(schools_id, name, addr_towncity, addr_province, description);

I haven't tested the code.
I assume that your user has FILE privilege, and that the file is to be read from the secure folder
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_secure_file_priv

Good luck,
Barry.