SQL Mode commonly used in MySQL
- 黄舟Original
- 2017-03-01 13:53:361169browse
sql mode defines the sql syntax, data verification, etc. that mysql should support, which makes it easier to use mysql in different environments. The common sql_mode defined in mysql is as follows
To modify the sql_mode command in mysql, you can use the SET SESSION SQL_MODE=sql_mode value, as follows
SET SESSION SQL_MODE='STRICT_TRANS_TABLES';
The above is the content of SQL Mode commonly used in MySQL. For more related information, please Follow the PHP Chinese website (www.php.cn)!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Detailed explanation of MySQL optimization stepsNext article：Detailed explanation of MySQL optimization steps