Advanced Search

Configuration Mysql 5.7

/ Published in: MySQL
Save to your folder(s)
Some configurations for mysql 5.7

Expand | Embed | Plain Text

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.