MySQL里改read_only变量代码,MYSQL代码库,德仔网

代码语言

代码分类

【MYSQL】 MySQL里改read_only变量

作者:kevin0216 / 发布于2013/5/28/ 1275

测试read_only的变量的用途。本以为设置为ON以后不可以修改表的内容，创建数据库、表等，结果发现可以建数据库，建表，往表加一条记录....


	C:\Documents and Settings\Administrator>mysql -u root
	Welcome to the MySQL monitor. Commands end with ; or \g.
	Your MySQL connection id is 2
	Server version: 5.6.11 MySQL Community Server (GPL)

	Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

	Oracle is a registered trademark of Oracle Corporation and/or its
	affiliates. Other names may be trademarks of their respective
	owners.

	Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

	mysql> show variables like 'read_only';
	+---------------+-------+
	| Variable_name | Value |
	+---------------+-------+
	| read_only | OFF |
	+---------------+-------+
	1 row in set (0.02 sec)

	mysql> set global read_only=on;
	Query OK, 0 rows affected (0.00 sec)

	mysql> show variables like 'read_only';
	+---------------+-------+
	| Variable_name | Value |
	+---------------+-------+
	| read_only | ON |
	+---------------+-------+
	1 row in set (0.00 sec)

	mysql> use test
	Database changed

	mysql> show tables;
	+----------------+
	| Tables_in_test |
	+----------------+
	| y2k |
	+----------------+
	1 row in set (0.00 sec)

	mysql> select * from y2k;
	+------------+---------------------+---------------------+
	| date | date_time | time_stamp |
	+------------+---------------------+---------------------+
	| 1998-12-31 | 1998-12-31 23:59:59 | 1998-12-31 23:59:59 |
	| 1999-01-01 | 1999-01-01 00:00:00 | 1999-01-01 00:00:00 |
	| 1999-09-09 | 1999-09-09 23:59:59 | 1999-09-09 23:59:59 |
	| 2000-01-01 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |
	| 2000-02-28 | 2000-02-28 00:00:00 | 2000-02-28 00:00:00 |
	+------------+---------------------+---------------------+
	5 rows in set (0.19 sec)

	mysql> insert into y2k values ('2000-02-29','2000-02-29 00:00:00',20000229000000
	);
	Query OK, 1 row affected (0.22 sec)

	mysql> select * from y2k;
	+------------+---------------------+---------------------+
	| date | date_time | time_stamp |
	+------------+---------------------+---------------------+
	| 1998-12-31 | 1998-12-31 23:59:59 | 1998-12-31 23:59:59 |
	| 1999-01-01 | 1999-01-01 00:00:00 | 1999-01-01 00:00:00 |
	| 1999-09-09 | 1999-09-09 23:59:59 | 1999-09-09 23:59:59 |
	| 2000-01-01 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |
	| 2000-02-28 | 2000-02-28 00:00:00 | 2000-02-28 00:00:00 |
	| 2000-02-29 | 2000-02-29 00:00:00 | 2000-02-29 00:00:00 |
	+------------+---------------------+---------------------+
	6 rows in set (0.00 sec)

	mysql> show variables like 'read_only';
	+---------------+-------+
	| Variable_name | Value |
	+---------------+-------+
	| read_only | ON |
	+---------------+-------+
	1 row in set (0.00 sec)

	mysql> create database new;
	Query OK, 1 row affected (0.03 sec)

	mysql> use new
	Database changed

	mysql> create table y2k (date DATE, time TIME);
	Query OK, 0 rows affected (0.80 sec)

	mysql> select database();
	+------------+
	| database() |
	+------------+
	| new |
	+------------+
	1 row in set (0.00 sec)

	mysql> insert into new.y2k values ('2013-5-25', '08:53:00');
	Query OK, 1 row affected (0.27 sec)

	mysql> select * from new.y2k;
	+------------+----------+
	| date | time |
	+------------+----------+
	| 2013-05-25 | 08:53:00 |
	+------------+----------+
	1 row in set (0.00 sec)

	mysql>

试试其它关键字

　改read_only　

同语言下

可能有用的

kevin0216贡献的其它代码(2)