Regarding the issue that dates cannot contain zero values ​​in higher versions of MySQL
2018-10-12 20:32:12
0
0
998

Export the database from MySQL5.6 version and then import it to MySQL5.7. Error:

Invalid default value for 'CREATE_TIME'


Check the reason It is said that starting from 5.7, there cannot be zero value in strict mode, and NOT-ZERO-DATE should be deleted in sql-model. However, when checking sql-model in mysql in phpstudy, this is not set, so why can't I import zero value?

reply all(0)
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template