mysql : creating database

To create a database in mysql do the following steps.

mysql> create database pydatabase;

This will create a database named pydatabase.


To list all the databases available use the below command

mysql> show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| pydatabase         |
+--------------------+
4 rows in set (0.02 sec)

To use a particular database instance use the command

mysql> use pydatabase;

Database changed

This will change to database pydatabase.

To display all the tables present in a database use the command

mysql > show tables;