too many errors in the Create table cmd ...
table name must not be quoted
int(8) is deprecated, will soon go away
zerofill is deprecated
desc is a reserved word, needs backticks till you change the name
primary key declaration fails
unique key is redundant
Too many errors to work past. Where was this Create Table stmt executed? If in 8.0, did you just ignore the errors & warnings?
Quote
Offending line:
00100298 3271 RTE 202 325 Terrain & RĂ©sidence 2021
Your table has 5 columns but the input line has 8 spaces and no quotes implying 9 columns if spaces are to delimit columns. How do you want MySQL to parse it? Please show the exact Load Data stmt yyou are using.