Configuration Mysql 5.7


/ Published in: MySQL

Some configurations for mysql 5.7


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.