[摘要]+------------+1 row in set (0.00 sec)mysql> INSERT INTO tn VALUES (NULL), (0), (1);Query OK, 3 r...
+------------+
1 row in set (0.00 sec)
mysql> INSERT INTO tn VALUES (NULL), (0), (1);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
然而如果我们修改SQL模式的话，就会报错：
mysql> SET sql_mode='STRICT_ALL_TABLES,ERROR_FOR_pISION_BY_ZERO';
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO tn VALUES (NULL), (0), (1);
ERROR 1365 (22012): pision by 0
2.表辅助功能
有时候修改SQL模式可能会导致分区表不可用。比如有些表只有在SQL模式为NO_UNSIGNED_SUBTRACTION才发挥作用，比如：
mysql> SELECT @@sql_mode;
+------------+
关键词：详细说明MySQL分区表的局限与局限的代码案例