Home >Database >Mysql Tutorial >SQL Mode commonly used in MySQL
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)!