SHOW DATABASES Syntax

1
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr]

example:

1
2
3
SHOW DTATBASES;
SHOW DATABASES LIKE 'django_%';
SHOW DATABASES WHERE `Database` LIKE '%django_%';

CREATE DATABASE syntax

1
2
3
4
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] ...

create_specification:
    [DEFAULT] CHARACTER SET [=] charset_name [DEFAULT] COLLATE [=] collation_name

example:

1
CREATE DATABASE IF NOT EXISTS `tests` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER DATABASE Syntax

1
2
3
4
5
6
ALTER {DATABASE | SCHEMA} [db_name]
    alter_specification ...

alter_specification:
    [DEFAULT] CHARACTER SET [=] charset_name
  | [DEFAULT] COLLATE [=] collation_name

example

1
ALTER DATABASE `tests` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

DROP DATABASE Syntax

1
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

example:

1
DROP DATABASE IF EXISTS `tests`;