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)!