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
Post a Comment