MySQL Learning (2) Creating and deleting databases

Create a database

{} Required | Select from front and back [] optional

Create {database | schema} [if not EXISTS] db_name [default] Character Set [=] Charset_name

Create a database T1

Create DATABASE T1;

View all databases

Show database;

If not exists (if it does not exist)

When you create the T1 database again, the system prompts that T1 already exists,

But when plus if not exists will overwrite, get a warning

See how the T1 database is encoded

Show CREATE DATABASE T1;

Modify how it is encoded

ALTER DATABASE T1 character set= GBK;

(The Character set section can be re-created without using the default encoding method)

Deleting a database

Dorp {Database|schema} [if exists] db_name

MySQL Learning (2) Creating and deleting databases