Importing CSV files to a table using SQLYog

I have two columns in my csv file but when I import the file, both columns go into one field, seperated by a commar leaving the second field with null values.

I need to import two columns from the csv file into two fields in SQLYog.

Can anyone tell me what I’m doing wrong?


how are you importing the file? you didn’t provide any detail on that.