Category "load-data-infile"

Error Code: 1265. Data truncated for column at row 1 when I tried to input csv file to MySQL

I created a table with a query: CREATE TABLE Department ( EmpID INT NOT NULL, Designation VARCHAR(80) NOT NULL, Department VARCHAR(80) NOT NULL, PRIMARY KEY(Emp

How to load data of string of date in csv to mysql database?

Here is a glimpse of my .csv file: Name,Start Date,End Date,Budget Class 1,1/1/2020,31/1/2020,"USD10,000.00" Class 2,1/2/2020,28/2/2020,"USD14,000.00" The date

Other Categories