I've problem with inserting data values from .csv file to MySQL data table.
My query as follows;
LOAD DATA INFILE 'C/Customers.csv' INTO TABLE pc.customers FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (CustID, RegDate, CName, CAddress, CPhone1, CPhone2, Order_OrderID)
It returns error msg as follows;
Error Code: 1406. Data too long for colum "CustID" at row 1.
FYI, my CustID datatype is varchar(255) and one of its data value is "C001". I'm using MySQL workbench.
Anyone pls help.. Thx