MySQL-csv insert into tables doesn't take effect

[Alexander Apprich]

M E Fieu wrote:
> Hi.. I create a data.csv file using excel file and
> convert to CSV as following
> 
> [root at box root]# more data.csv
> departmentID,name,job
> 1,IT,IT-infra
> 2,HR,Human Resource
> 3,Finance,Financing
> 

I just tried creating a csv file and convert it via dos2unix.
For some reason the separator in my file looks different.

apprich at elmstreet org_pl $ dos2unix ~/Mappe1.csv
dos2unix: converting file /home/apprich/Mappe1.csv to UNIX format ...
apprich at elmstreet org_pl $ less ~/Mappe1.csv
1;a
2;b
3;c
4;d

Could you try it with ";" as separator instead of "," ?!
Other than that, can't help ya, sorry

[snip]

Alex