rpl_delete_all.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- create database mysqltest;
- drop database if exists mysqltest;
- Warnings:
- Note 1008 Can't drop database 'mysqltest'; database doesn't exist
- show tables from mysqltest;
- ERROR HY000: Can't read dir of './mysqltest/' (Errcode: X)
- create table t1 (a int);
- drop table if exists t1;
- Warnings:
- Note 1051 Unknown table 't1'
- select * from t1;
- ERROR 42S02: Table 'test.t1' doesn't exist
- create table t1 (a int);
- insert into t1 values(1);
- delete from t1;
- select * from t1;
- a
- insert into t1 values(1);
- insert into t1 values(2);
- update t1 set a=2;
- select * from t1;
- a
- 2
- 2
- drop table t1;