View your own SQL mode in MySQL

View your own SQL mode in MySQL

Enter Password:welcome to the MySQL Monitor.  Commands End With; or \g.your MySQL connection ID is 9450Server version:5.6.24-log mysql Community Server (GPL) Copyright (c) #, Ora CLE and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> select @ @sql_mode; +------------------------------------------- ---------------------+| @ @sql_mode                                                     |+----------------------------------------------------------------+| Strict_trans_tables,no_auto_create_user,no_engine_substitution |+---------------------------------------------- ------------------+1 Row in Set (0.00 sec)

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

View your own SQL mode in MySQL