SQL Create Database Statement
Submitted by admin on Saturday, March 26, 2011 - 21:50.
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
Add new comment
- Add new comment
- 235 views