Posted By

ironcrema on 05/27/17

Tagged

mysql

Versions (?)

Last Edited at 05/27/17 02:31am

Statistics

Viewed 3858 times

Favorited by 0 user(s)

Related snippets

Configuration Mysql 5.7

/ Published in: MySQL

Some configurations for mysql 5.7

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

For show sql_mode configuration:
 
SELECT @@sql_mode 
 
For set sql_mode in my.cnf:
 
sql-mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Report this snippet Tweet

Comments

You need to login to view comments.