1DROP DATABASE IF EXISTS d1;
2CREATE DATABASE d1;
3SHOW DATABASES;
4Database
5d1
6information_schema
7mtr
8mysql
9performance_schema
10sys
11test
12SHOW DATABASES LIKE 'd%';
13Database (d%)
14d1
15SHOW DATABASES LIKE '%';
16Database (%)
17d1
18information_schema
19mtr
20mysql
21performance_schema
22sys
23test
24USE d1;
25DROP DATABASE d1;
26CREATE SCHEMA d1;
27SHOW SCHEMAS;
28Database
29d1
30information_schema
31mtr
32mysql
33performance_schema
34sys
35test
36SHOW SCHEMAS LIKE 'd%';
37Database (d%)
38d1
39SHOW SCHEMAS LIKE '%';
40Database (%)
41d1
42information_schema
43mtr
44mysql
45performance_schema
46sys
47test
48USE d1;
49DROP SCHEMA d1;
50