mysql help commands

mysql help commands

2017-06-29
mysql> select version();
+-------------------------+
| version()               |
+-------------------------+
| 5.7.18-0ubuntu0.16.04.1 |
+-------------------------+
1 row in set (0,00 sec)


mysql> show variables like '%version%';

mysql> show variables like '%innodb_strict%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_strict_mode | ON    |
+--------------------+-------+
1 row in set (0,01 sec)

mysql> set innodb_strict_mode = OFF;
Query OK, 0 rows affected (0,00 sec)

mysql>  show variables like '%innodb_strict%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_strict_mode | OFF   |
+--------------------+-------+
1 row in set (0,00 sec)