How can we force MySQL out of TRADITIONAL mode?

With the help of the following command we can force MySQL out of TRADITIONAL mode −

mysql> Set SQL_MODE ='';
Query OK, 0 rows affected (0.00 sec)

Nishtha Thakur

Published on 19-Feb-2018 13:46:00

• Related Questions & Answers
• How can we find out the current transaction mode in MySQL?
• How can we run MySQL statements in batch mode?
• How we can come out of an infinite loop in Python?
• How can we find out the storage engine used for a particular table in MySQL?
• How can we create MySQL views?
• How can we modify column/s of MySQL table?
• How can we get the metadata of MySQL events?
• How can we get the structure of a MySQL view as we can get the structure of a MySQL table?
• How can we get the definition of a MySQL view as we can get the definition of a MySQL table?
• How can I force clients to refresh JavaScript files?
• How can we use MySQL SUM() function?
• How can we combine functions in MySQL?
• How can we invoke MySQL stored procedure?
• How can we implement a MySQL transaction?
• How can we start MySQL event scheduler?