fields terminated by ','

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/EMPLOYEES.CSV' INTO TABLE employees FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'

LOAD DATA INFILE,$file, replace INTO TABLE brands FIELDS TERMINATED BY','LINESTERMINATED BY'\n' (name)

LOAD DATA INFILE Client.dat APPEND INTO TABLE client FIELDS TERMINATED BY ',' (clientno,fname,lname,telno,preftype,maxrent)