Error in importing CSV data into MySQL database using PHPMyAdmin -


I am importing the CSV file into the database using PHPMyAdmin. I have kept meaningless for those columns which I just do not want to import prices. When I import the CSV, it is giving me an error: # 1292 - Wrong Date Time Value: '' for 'column' updated_at 'on line 1.

Is there no way to touch this error? Value in the 'Update_at' column.

Note: The 'updated' date is the Date column, it is created using the following query.

  update table labdata1 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP updated at CURRENT_TIMESTAMP;  


Comments