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 (m.sbmmt.com)!