Common MySQL commands,

Common MySQL commands,

1. Create a database

Command create database name charset = utf8;

mysql> create database python charset=utf8;Query OK, 1 row affected (0.00 sec)

2. display the database

Command show databases;

mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || python             |+--------------------+4 rows in set (0.00 sec)

3. Specify the database

Command use Database Name;

mysql> use python;Database changed

4. view the currently used database

Command select database ();

mysql> select database();+------------+| database() |+------------+| python     |+------------+1 row in set (0.00 sec)

5. delete a database

Command drop database name;

mysql> drop database python;Query OK, 0 rows affected (0.00 sec)