O'Reilly logo

MySQL 8 Administrator's Guide by Subhash Shah, Hetal Oza, Ankit Bhavsar, Chintan Mehta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The available SQL modes

This section describes all the available SQL modes. Out of them, the first three are the most important SQL modes:

  • ANSIThis 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required