Eternal Night

Tagged: Incorrect datetime value

在 Navicat for MySQL 中，将表从一个数据库复制至另一个数据库时，报错：[ERR] 1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'created_at_gmt' at row 1 0

SQL / Homestead / MySQL 5.7 / MySQL 8.0 / Navicat / Application Tools / Homestead v13 / Database / Navicat for MySQL / Programming Language / Navicat for MySQL 12 / Terminal/Remote Login / MySQL / Database Management Tools

In Navicat for MySQL, when the table is copied from one database to another, an error is reported:[ERR]1292 – Incorrect DateTime Value:0000-00-00 00:00:00for columnCREATED_AT_GMTAT ROW 1 (in MySQL 8.0)

浏览量： 2 1. In Navicat for MySQL, when the table is copied from one database to another, an error is reported:[ERR]1292 – Incorrect DateTime Value:0000-00-00 00:00:00for columnCREATED_AT_GMTat row 1. as shown in Figure 1...