SQL Create Database Statement

Besides creating the database from the DBMS software like Oracle, MyQL, Microsoft Access etc. We can also create database with the query language. It is as simple as writing a SELECT, INSERT, UPDATE, DELETE Statement.

Creating a database using query language is very useful if for example you deploy your application to a computer that doesn’t have a database yet.

We can create a new database with the following syntax

SQL Create Database Syntax

CREATE DATABASE database_name

Example # 1

Now let's create a new database named "new_db".

CREATE DATABASE new_db

If you are using PhpMyAdmin you can simply paste the code above at the SQL table can click execute button to create a database named "new_db".

Comments

Submitted byAnonymous (not verified)on Sat, 04/09/2011 - 20:25

i need database queries for bill book system
Submitted byAnonymous (not verified)on Sat, 06/11/2011 - 11:24

very useful one and im learning more and more

Add new comment