Ignore empty rows while loading data into a table
load data local infile 'C:\\temp\\abc.csv'
into table table_name
fields terminated by ',' ignore 1 lines 
(@col1,@col2,@col3,@col4)
set 
table.column_name = @col1,
table.column_name = @col2,
table.column_name = @col3,
table.column_name = @col4;


(@col1,.....) extend the number of columns to your actual number of columns in csv file.
and relate these column numbers to table columns.
It will be done.