rpl_delete_all.result 705 Bytes
Newer Older
1 2 3 4 5 6
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;
7 8
create database mysqltest;
drop database if exists mysqltest;
9
Warnings:
10 11
Note	1008	Can't drop database 'mysqltest'; database doesn't exist
show tables from mysqltest;
12
ERROR 42000: Unknown database 'mysqltest'
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;