flush_block_commit.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- drop table if exists t1;
- create table t1 (a int) engine=innodb;
- begin;
- insert into t1 values(1);
- flush tables with read lock;
- select * from t1;
- a
- commit;
- select * from t1;
- a
- unlock tables;
- begin;
- select * from t1 for update;
- a
- 1
- begin;
- select * from t1 for update;
- flush tables with read lock;
- commit;
- a
- 1
- unlock tables;
- commit;
- begin;
- insert into t1 values(10);
- flush tables with read lock;
- commit;
- unlock tables;
- flush tables with read lock;
- unlock tables;
- begin;
- select * from t1;
- a
- 1
- 10
- show create database test;
- Database Create Database
- test CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */
- drop table t1;