mysql改variable_怎样改变mysql的variables的变量⾥的值.通
过什么命令
匿名⽤户
1级
2017-09-25 回答
MySQL系统变量(system variables)实际上是⼀些系统参数，⽤于初始化或设定数据库对系统资源的占⽤，⽂件存放位置等等。mysql> show variables like "log";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log | OFF |
+---------------+-------+
1 row in set (0.00 sec)
variable used in lambdamysql> set @log=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like "log";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log | OFF |
+---------------+-------+
1 row in set (0.00 sec)
mysql> set @log="ON";
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like "log";
+---------------+-------+

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。