1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
SELECT SHOW_SCHEMA_PROTO('not_exists');
ERROR 42000: Unknown database 'not_exists'
CREATE DATABASE foobar COLLATE = utf8_bin;
SELECT SHOW_SCHEMA_PROTO('foobar');
SHOW_SCHEMA_PROTO('foobar')
name: "foobar"
collation: "utf8_bin"
DROP DATABASE foobar;
CREATE DATABASE foobar;
SELECT SHOW_SCHEMA_PROTO('foobar');
SHOW_SCHEMA_PROTO('foobar')
name: "foobar"
collation: "utf8_general_ci"
ALTER DATABASE foobar COLLATE = utf8_bin;
SELECT SHOW_SCHEMA_PROTO('foobar');
SHOW_SCHEMA_PROTO('foobar')
name: "foobar"
collation: "utf8_bin"
DROP DATABASE foobar;
|