Mysql database Operations Common commands summary _mysql

Creating a Database

The simplest way:

Copy Code code as follows:

CREATE DATABASE my_db;

Or is:

Copy Code code as follows:

CREATE DATABASE IF not EXISTS my_db;

To create a UTF8-encoded database:

Copy Code code as follows:

CREATE DATABASE IF not EXISTS my_db default character set UTF8 COLLATE utf8_general_ci;

Then the default character set for all data tables created under this database is UTF8, and note that the following sentence, "COLLATE utf8_general_ci", roughly means sorting according to the UTF8 Change code format.

To view a list of databases:

Copy Code code as follows:

show databases;

Working with databases:

Copy Code code as follows:

Use my_db;

To view the database default encoding:

Copy Code code as follows:

Show variables like ' character_set_% '

+--------------------------+-------------------------------------------------------+
| variable_name | Value |
+--------------------------+-------------------------------------------------------+
| character_set_client | UTF8 |
| character_set_connection | UTF8 |
| Character_set_database | Latin1 |
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | Latin1 |
| Character_set_system | UTF8 |
| Character_sets_dir | /usr/local/mysql-5.5.28-linux2.6-i686/share/charsets/|
+--------------------------+-------------------------------------------------------+

You can see Character_set_database is lantin1.

To modify the database encoding:

Copy Code code as follows:

ALTER DATABASE my_db character set latin1;

To delete a database:

Copy Code code as follows:

Drop database my_db;

Or is:

Copy Code code as follows:

Drop database IF EXISTS my_db;