search

Home  >  Q&A  >  body text

Regarding the issue that dates cannot contain zero values ​​in higher versions of MySQL

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?

2277 days ago1024

reply all(0)I'll reply

No reply
  • Cancelreply