MySQL-load data infile- invalid data validation

Is it possible to validate the data and load it in a table using load data infile? This is the query load data local infile 'C:/Users/970685/Desktop/SFcheck.csv' into table wow_macro.starting_footage_stg fields terminated by ',' IGNORE 1 LINES FIELDS ESCAPED BY \N (store_id,category_id,footage,plan_id,@merch_id) ; This is data in CSV: store_id category-id footage plan_id merch_id 1 1 3 1 fdfd All the fields are INT in the table but when I execute the query the value 'fdfd' is not validated but saved as 0. (I have also given not null in the table and have not set any default value)