mysql - How do I make load data infile give an error -


is there way verify in mysql file contains columns supposed when uploading csv file?

currently reason when upload file mysql doesn't give error when upload file few columns.

my query:

load data infile 'path/file.csv' table raw fields terminated ',' enclosed '"' lines terminated ' ' (x1,   x2,   x3) 

i give error when uploading file 2 columns. possible?


Comments