Mysql Common Errors

I have been using php + mysql recently and may encounter some problems.

I have been using php + mysql recently and may encounter some problems.

#1067-Invalid default value for 'xxx'

This error occurs when a field in the table is modified. Display: The field name already has an error.
You have to delete this field and add it again.

UTF-8 import MYSQL Chinese no display
Today, I exported the local MYSQL Data to the web service and found that all Chinese characters were missing. The configuration is as follows:

Program code
Export the database 5.0.45. Character Set: UTF-8
Import database 5.0.22, also UTF-8

The result shows that the phpadmin version is incompatible, so that the exported data is faulty. Use the mysqldump command to export the data.

Program code
Mysqldump-uroot-p123456 thfxw> d: \ ym. SQL