SQL MODE MySQL Incorrect datetime value: '0000-00-00 00:00:00' 1978

[yehlu]

代碼: 選擇全部

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