Query and setting method of sql_mode in MySQL

This article mainly introduces "the query and setting method of sql_mode in MySQL". In the daily operation, I believe that many people have doubts about the query and setting method of sql_mode in MySQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "query and setting method of sql_mode in MySQL". Next, please follow the editor to study!

1. Perform SQL view.

Select @ @ session.sql_mode

Global level: viewin

Select @ @ global.sql_mode

Modify

Set @ @ session.sql_mode='xx_mode'set session sql_mode='xx_mode'

Global level: modifyin

Set global sql_mode='xx_mode';set @ @ global.sql_mode='xx_mode'

Session can be omitted. Default session, valid only for the current session.

2. For global modification, advanced permissions are required, which will only take effect on the next connection and will not affect the current session, and will expire when MySQL is restarted, because the corresponding values in the configuration file will be re-read when MySQL is restarted. If you want to take effect permanently, you need to modify the values in the configuration file.

Vi / etc/ my.cnf [mysqld] sql-mode = "xx_mode"

Save the exit, restart the server, and take effect permanently.

At this point, the study on "the query and setting method of sql_mode in MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!