Tag Archives: Fault summary

MySQL reports error 1292 (22007) failure

Error in editing MySql to change the date, the code is as follows:
mysql> Insert into date values (‘ Zhangsan ‘,92-01-02,99-03-04);
ERROR 1292 (22007): pendate value: ’89’ for column ‘birth’ at row 1
changed to
mysql> Insert into date values (‘zhangsan’,19920102,19990304);
Query OK, 1 row affected (0.13 SEC)
succeeds.
 
It should be the length of the date input.

Python reports oserror: initializing from file failed

phenomenon description:

When

opens a file, the newspaper Initializing from file failed to initialize the file.

the original statement is:

df=pd.read_csv(r’ job list query by original expected date 529.csv’)

reason analysis:

is because the file path contains Chinese. Since the default engine of read_csv function is C, Chinese recognition is not supported, so this error is reported. This is a common problem when using notebook to open files.

solution:

change engine=’python’ executes successfully.

df=pd.read_csv(r’ job list query by original expected date 529. CSV ‘,engine=’python’)