This section describes all the available SQL modes. Out of them, the first three are the most important SQL modes:
- ANSI: This mode is used to change syntax and behavior, by making it closer to standard SQL.
- STRICT_TRANS_TABLES: As the name implies, this mode is related to transaction and it is mainly used for transactional storage engines. When this mode is enable for nontransactional tables, MySQL 8 will convert invalid values to the closest valid value and insert the adjusted value into the column. If the value is missing, then MySQL 8 will insert an implicit default value related to the column's data type. In this case, MySQL 8 will generate a warning message instead of an error message, and continue with the statement ...
