How to avoid error when importing CSV to MySQL on PHPMyAdmin?

Question

PHP

Hello, I have a column with TimeTamp, if it is not included in CSV, I get a column mismatch error. If inserted, the date is inserted as 0000-00-00 00:00:00.

How can this be avoided? Ideally, TimeTamp would be filled in automatically, as it should be, that is, how to make it so that MySQL accepted in data not my import, but the execution of the function. Well, at the extreme, how to put the date in excel csv? I've tried different formats without success...

Answer 1

checkbox "The first line of the file contains the names of the table fields (if this option is not selected, then the first line will be part of the data)".
In the file, in the first line, indicate which fields you are using (how you want to fill in the columns), then the unspecified ones will be skipped when inserting.
Option - xls date to convert to text in another column. look in google date to text xls