Hi,
I tried to insert CSV file in MySQL but getting error.
FYI, Table successfully created
create table if not exists employees1
(
EmployeeID int,
Name varchar(50) not null,
Salary NUMERIC
);
bulk insert employees1
from ‘C:\Users\ekhmaku\Data12.csv’
with
(
Firstrow=2,
fieldterminator=‘,’,
rowterminator=‘\n’,
maxerrors=0
)
go
please suggest this is correct way to insert the file or is there any other way if any.
Appreciate your response.!!