HIOX FREE MySQL Tutorial - Creating/Create Database, Show Database Queries

Topic

How to create/creating a database in MySQL?

Explanation

     Before going to create a database check whether there is any database with the name you are going to create. Check this by the following SHOW statement:

mysql> show databases;

     This query will list the available databases. Please note that MySQL is case insensitive. So you can give the query with different cases also. So show dataBASES; , SHOW dataBASES; will also work.

     Once you have confirmed that you don't have a database with the name you intended to create, then you can create your own database by,

mysql> create database sample;

     Please note that only in Unix the database name is case sensitive. The above query will create an empty database and it wouldn't contain any tables.

Create/Show Database in MySQL