How can I see the specific value of the sql mode

Question

There are some sql mode values in MySQL   ANSI    IGNORE SPACE    STRICT TRANS TABLES  etc  How can I see the one particular value  The manual says      You can retrieve the current mode by issuing a SELECT   sql mode   statement    But it just shows nothing  just one blank field in a table with   sql mode as a column name

User · Answer

You can also try this to determine the current global sql_mode value:

SELECT @@GLOBAL.sql_mode;

or session sql_mode value:

SELECT @@SESSION.sql_mode;

I also had the feeling that the SQL mode was indeed empty.

User · Answer

It s only blank for you because you have not set the sql mode  If you set it  then that query will show you the details   mysql gt  SELECT   sql mode   ------------      sql mode    ------------                  ------------  1 row in set  0 00 sec   mysql gt  set sql mode ORACLE  Query OK  0 rows affected  0 00 sec   mysql gt  SELECT   sql mode   ----------------------------------------------------------------------------------------------------------------------      sql mode                                                                                                              ----------------------------------------------------------------------------------------------------------------------    PIPES AS CONCAT ANSI QUOTES IGNORE SPACE ORACLE NO KEY OPTIONS NO TABLE OPTIONS NO FIELD OPTIONS NO AUTO CREATE USER    ----------------------------------------------------------------------------------------------------------------------  1 row in set  0 00 sec

User · Answer

You need to login to your mysql terminal first using mysql -u username -p password Then use this  SELECT   sql mode  or SELECT   GLOBAL sql mode   output will be like this  STRICT TRANS TABLES STRICT ALL TABLES NO ZERO IN DATE NO ZERO DATE ERROR FOR DIVISION BY ZERO TRADITIONAL NO AUTO CREATE USER NO ENGINE SUB You can also set sql mode by this  SET GLOBAL sql mode TRADITIONAL

[mysql] How can I see the specific value of the sql_mode?

Examples related to mysql