SQL Tutorial » SQL CREATE DataBase Statement

How do I create a SQL database?

Before we can do anything, we need to create a database first. Suppose you already have an SQL or MySQL server available for use, and you have all the necessary privileges, ie server_name, user_names and a password, if not, please refer to the startup guide.

CREATE DATABASE statement is used to create a new SQL database.

Syntax:

 

How do I create a SQL database for beginners?

The following SQL statement creates a database on the server called db_test:

Related subjects:
SQL select data from DB SQL update DataBase PHP select / view data Conect to MySQLi SQL insert into table

Tags: sql database create: table, user, dchema, view, index, table primary key, created date, new user, table query.
sql creare: table, datebase, column, foreign key, trable primary key, user, schema, temp table, view, index
How do I create a SQL database?
Can I create my own SQL database?
How do I create a SQL database example?
Create a SQL database for beginners?
What is SQL create?
How do I create a SQL script?
Can I create my own SQL database?

 

1: Invoke the MySQL command-line tool

To connect to the MySQL server we must invoke the MySQL command line. To log in as root user, type the following command in terminal and press enter. 

Command line tool mysql> prompt:

 

2: Creating a MySQL Database

Create the database named db_test.

If the database SQL is created successfully you'll can see the output something as:

Query OK, 1 row affected (0.02 sec)

 

If you create a database that is already exists you'll have an error message and to avoid this mistake in MySQL you can use a clause as "IF NOT EXISTS":

 

sql database create: table, user, dchema, view, index, table primary key, created date, new user, table query.
sql creare: table, datebase, column, foreign key, trable primary key, user, schema, temp table, view, index
How do I create a SQL database?
Can I create my own SQL database?
How do I create a SQL database example?
Create a SQL database for beginners?
What is SQL create?
How do I create a SQL script?
Can I create my own SQL database?
SQL CREATE DataBase Statement - sql tutorial