Create a database : Create Database « Database « MySQL Tutorial






  1. MySQL Tutorial
  2. Database
  3. Create Database

Syntax:

CREATE DATABASE <database>;

mysql>
mysql>
mysql> CREATE DATABASE myDatabase;
Query OK, 1 row affected (0.03 sec)

mysql>
mysql> drop database myDatabase;
Query OK, 0 rows affected (0.01 sec)

mysql>
Under Unix, database and table names are case sensitive.
Under Windows, this restriction does not apply
mysql>








3.1.Create Database
3.1.1.Create a database
3.1.2.Creating a database does not select it for use
3.1.3.Database, Table, and Column Definition with Character and collate