首页 > itarticle > mysql

mysql

admin 12月 02, 2020 0

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

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

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`;