rpl_delete_all.result 702 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11
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 test1;
drop database if exists test1;
Warnings:
Note	1008	Can't drop database 'test1'; database doesn't exist
show tables from test1;
12
ERROR HY000: Can't read dir of './test1/' (Errcode: X)
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
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;