## SQL Modes Index 

## X 

[index top] 

## XA_RECOVER_ADMIN 

Section 13.7.1.6, “GRANT Statement” Section 6.2.2, “Privileges Provided by MySQL” Section 5.1.8, “Server System Variables” Section 13.3.8.1, “XA Transaction SQL Statements” 

A | E | H | I | N | O | P | R | S | T 

## A 

[index top] 

## ALLOW_INVALID_DATES 

Section 11.2, “Date and Time Data Types” Section 12.7, “Date and Time Functions” Section B.3.4.2, “Problems Using DATE Columns” Section 5.1.11, “Server SQL Modes” Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types” 

## ANSI 

Section 9.2.5, “Function Name Parsing and Resolution” Section 5.1.11, “Server SQL Modes” Section 13.7.7.13, “SHOW CREATE VIEW Statement” Section 26.3.48, “The INFORMATION_SCHEMA VIEWS Table” 

## ANSI_QUOTES 

Section 13.1.20.5, “FOREIGN KEY Constraints” Section 4.5.1.6, “mysql Client Tips” Section 1.7.1, “MySQL Extensions to Standard SQL” Section 4.5.4, “mysqldump — A Database Backup Program” Section 8.9.3, “Optimizer Hints” Section 9.2, “Schema Object Names” Section 5.1.11, “Server SQL Modes” Section 9.1.1, “String Literals” 

## E 

[index top] 

## ERROR_FOR_DIVISION_BY_ZERO 

Section 12.25.3, “Expression Handling” Section A.3, “MySQL 8.0 FAQ: Server SQL Mode” Section 12.25.5, “Precision Math Examples” Section 5.1.11, “Server SQL Modes” 

