MySql tossing NOTE 2: The default value cannot be set for the text/blog type, and two CURRENT_TIMESTAMP cannot exist.

In the reverse engineering of CYQ. Data framework, there are two more MySQL problems. Record them first.

 

1: The default value of time is CURRENT_TIMESTAMP. Two dates in a table cannot be set: CURRENT_TIMESTAMP.

Solution:

Set only one.

However, in reverse engineering, if two or more settings are met, to ensure normal data import, the default value of the date is directly canceled.

 

2: The default value cannot be set for the text/blog type. Because other database types can have default values, the default value is usually set for conversion, but the default value cannot be set by default.

Solution:

Modify the my. ini configuration file to cancel strict control of the strict mode.

However, in reverse engineering data import, to avoid errors or prompt users to modify the configuration, cancel the default value.

 

Today, I have been tossing around for a long time, and finally I have all the differences between several databases. The reverse engineering of the CYQ. Data framework is basically complete.