SQL mode, or
sql_mode is a MySQL system variable meant to configure operational characteristics of the MySQL server.
You apply SQL modes depending on the clients. You can change the SQL mode by using the
sql_mode system variable.
There may be a global SQL mode for operating requirements, however you may specify an SQL mode specifically to a session if required. Modes affect the SQl syntax and data validation checks.
The default SQL modes are: