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

回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

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
回覆文章

回到「MySQL」