2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP DATABASE IF EXISTS mysqltest_prometheus;
8
DROP DATABASE IF EXISTS mysqltest_sisyfos;
9
DROP DATABASE IF EXISTS mysqltest_bob;
10
DROP DATABASE IF EXISTS mysqltest_bob;
11
CREATE DATABASE mysqltest_prometheus;
12
CREATE DATABASE mysqltest_sisyfos;
13
CREATE DATABASE mysqltest_bob;
14
USE mysqltest_sisyfos;
15
CREATE TABLE t1 (b int);
16
INSERT INTO t1 VALUES(1);
18
CREATE TABLE t2 (b int);
19
INSERT INTO t2 VALUES(2);
20
ALTER DATABASE mysqltest_sisyfos CHARACTER SET latin1;
21
USE mysqltest_sisyfos;
22
ALTER DATABASE mysqltest_bob CHARACTER SET latin1;
23
SHOW DATABASES LIKE 'mysql%';
29
SHOW DATABASES LIKE 'mysql%';
34
DROP DATABASE IF EXISTS mysqltest_sisyfos;
35
USE mysqltest_prometheus;
36
CREATE TABLE t1 (a INT);
37
INSERT INTO t1 VALUES (1);
38
CREATE DATABASE mysqltest_sisyfos;
39
USE mysqltest_sisyfos;
40
CREATE TABLE t2 (a INT);
41
SHOW DATABASES LIKE 'mysql%';
47
SHOW DATABASES LIKE 'mysql%';
52
USE mysqltest_prometheus;
54
Tables_in_mysqltest_prometheus
56
USE mysqltest_sisyfos;
58
Tables_in_mysqltest_sisyfos
60
DROP DATABASE IF EXISTS mysqltest_prometheus;
61
DROP DATABASE IF EXISTS mysqltest_sisyfos;
62
DROP DATABASE IF EXISTS mysqltest_bob;