Posted By

ironcrema on 05/27/17


Tagged

mysql configuration settings


Versions (?)

Configuration Mysql 5.7


 / Published in: MySQL
 

Some configurations for mysql 5.7

  1. For SHOW sql_mode configuration:
  2.  
  3. SELECT @@sql_mode
  4.  
  5. For SET sql_mode IN my.cnf:
  6.  
  7. 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  

You need to login to post a comment.