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 I create MySQL stored procedure with OUT parameter?
• How can we create a MySQL function to find out the duration of years, months, days, hours, minutes and seconds?
• How can we list all the columns of a MySQL view as we can list the columns of a MySQL table?
• How do we use Python in interactive mode?
• How do we use Python in script mode?