My system is apple, using navicat import Excel data, display Incorrect date value: '0000-00-00' for column 'date' at row 28. According to the way of people carried out the following methods:
1, modify the original excel in date show that modified cell form to date, and there are data; Or complains;
2, change my CNF file: after search found no this file; (1), I from the command line into the mysql/support - files folder, through vim. Create a new my CNF, copying the content inside; Not: wq! Save, tip me without permission; This road impassability. (2), manually enter/etc folder, add my. The CNF file, and joined together sql_mode statement sql_mode=NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, mysql at this time can't normal boot; No further;
You genuflect is begged god help me to solve my this mistake

CodePudding user response:

If the date can be null to excel in the '0000-00-00' data deleted; If not null, then into a meaningful day, this has nothing to do with excel display format should be

CodePudding user response:

The original list of data are all meaningful date