Slide 45
Slide 45 text
互換SQLモード
Compatibility SQL mode
まあ知ってる人の方が少ないとは思う
最近MariaDBが sql_mode = oracle を使ってOracle互換の構文を~
とかやってた気がする
‐
mysql57 5> SET sql_mode = 'oracle';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql57 5> SELECT @@sql_mode;
+------------------------------------------------------------------------------------------------
----------------------+
| @@sql_mode
|
+------------------------------------------------------------------------------------------------
----------------------+
| PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTION
S,NO_AUTO_CREATE_USER |
+------------------------------------------------------------------------------------------------
----------------------+
1 row in set (0.00 sec)
mysql80 15> SET sql_mode = 'oracle';
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'oracle'
44/108