Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
DBMS BCA Unit-3 Introduction - SQL SQL - Data Types DDL - Commands SQL - CREATE DATABASE SQL - SELECT DATABASE SQL - DROP DATABASE SQL - CREATE TABLE SQL - DESCRIBE Statement SQL - DROP TABLE SQL - ALTER Statement SQL - INSERT INTO Statement SQL - DELETE Statement SQL - UPDATE Statement SQL - FOREIGN KEY SQL - INSERT INTO Example


SQL - CREATE DATABASE

The SQL CREATE DATABASE statement is used to create a new SQL database.
The basic syntax of this CREATE DATABASE statement is:

CREATE DATABASE <Database Name>;

For example:
mysql> create database testdb;
Query OK, 1 row affected (0.00 sec)

mysql>

Once a database is created, you can check it in the list of databases as follows:
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| demo               |
| info               |
| mysql              |
| performance_schema |
| sys                |
| testdb             |
+--------------------+
7 rows in set (0.00 sec)

mysql>