How to correctly import a CSV file with a table into the database from the console?

Question

MySQL

I'm new to MySql, but here I needed to import a table into the database.
I am importing a CSV, the infection does not recognize the column with the time of the relevance of the entry.
I load it like this:
Load data local infile '/dir/filename.csv' into table tablename fields terminated by ';';
Where to dig?

Answer 1

I think this is the problem

Answer 2

Thank you.