# `ERROR_FOR_DIVISION_BY_ZERO`

__*ERROR_FOR_DIVISION_BY_ZERO SQL 模式*__

+ `SQL_MODE: ERROR_FOR_DIVISION_BY_ZERO`

```8
tidb> CREATE TABLE test.dropme (id int);
ERROR 1050 (42S01): Table 'test.dropme' already exists
tidb> SELECT ~!@8/0@!~;
+------+
| 8/0  |
+------+
| NULL |
+------+
1 row in set, 1 warning (0.01 sec)

tidb> INSERT INTO test.dropme (~!@8/0@!~);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 26 near "8/0)" 
tidb> SELECT @@SQL_MODE;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@SQL_MODE                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
```
--------------------------------------------------------