返回顶部

收藏

MySQL里改read_only变量

更多

测试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>
--该片段来自于http://outofmemory.cn

标签:sql,数据库

收藏

0人收藏

支持

0

反对

0

»更多 您可能感兴趣的代码
  1. 2013-07-23 16:18:20Sql Server中Case使用方法 by 自由魂
  2. 2013-08-09 14:03:09命令查看SQL2008中表的索引数据 by YuChao
  3. 2014-02-17 16:06:25Oracle统计表的数据行和数据块信息 by Sycro
  4. 2014-03-15 18:43:08PostgreSQL 列举和停止执行中的 sql by xuleaper
  5. 2014-03-28 16:40:31去除外键的存储过程 by 董一碗
  6. 2014-04-09 20:10:31oracle 回收站管理 by YuChao
  7. 2014-04-25 09:36:11mysql导出csv by 张少华
  8. 2014-05-02 10:44:58复制存储过程 by Ev4n
  9. 2014-05-13 09:55:38删除所有存储过程 by xuleaper
  10. 2014-07-07 21:34:29Oracle 表结构及数据复制 by Merrill
  11. 2014-07-27 10:48:58SQL中的事务处理机制--sp_lock2 by 吴红军

发表评论