> For the complete documentation index, see [llms.txt](https://help.gameixa.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.gameixa.com/gameixa-wiki/global/web-hosting/plesk/sql-mode.md).

# SQL Mode

### SQL mode value should be as follows

{% code overflow="wrap" %}

```sql
ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
```

{% endcode %}

### **To set SQL mode on your hosting, you need to paste the following code into the SQL section.**

{% code overflow="wrap" %}

```sql
SET GLOBAL SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
SET SESSION SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
SET SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
```

{% endcode %}
