SQL MODE MySQL Incorrect datetime value: '0000-00-00 00:00:00' 1978
發表於 : 2019-03-19 17:18:17
代碼: 選擇全部
MariaDB [> SET SQL_MODE='ALLOW_INVALID_DATES';
Query OK, 0 rows affected (0.000 sec)
[mysqld]
MariaDB []> SET GLOBAL SQL_MODE='ALLOW_INVALID_DATES';
Query OK, 0 rows affected (0.000 sec)
MariaDB []> SELECT @@SESSION.sql_mode;
+---------------------+
| @@SESSION.sql_mode |
+---------------------+
| ALLOW_INVALID_DATES |
+---------------------+
1 row in set (0.000 sec)
MariaDB []> SELECT @@GLOBAL.sql_mode;
+---------------------+
| @@GLOBAL.sql_mode |
+---------------------+
| ALLOW_INVALID_DATES |
+---------------------+
1 row in set (0.000 sec)
MariaDB []> exit