Skip to Main Content
MySQL 8 Administrator???s Guide
book

MySQL 8 Administrator???s Guide

by Chintan Mehta, Hetal Oza, Subhash Shah, Ravi Shah
February 2018
Intermediate to advanced content levelIntermediate to advanced
510 pages
16h 10m
English
Packt Publishing
Content preview from MySQL 8 Administrator???s Guide

The available SQL modes

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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

Anthony Molinaro, Robert de Graaf

Publisher Resources

ISBN: 9781788395199Supplemental Content