AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP, SQL

SQL CREATE DataBase Statement


<< Previous Page
SQL tutorial
Next Page >>
SQL tutorial

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:

CREATE DATABASE database_name;

 

SQL create database if not exists

How do I create a SQL database for beginners?

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

CREATE DATABASE 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?

 

Create a database in MySQL using the command-line tool

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:

shell> mysql -u root -p

 

2: Creating a MySQL Database

Create the database named db_test.

mysql> CREATE DATABASE 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)

 

SQL create database that is already exists

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":

mysql> CREATE DATABASE IF NOT EXISTS db_test;

 



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

Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.


Home - Database
SQL - Database
SQL Syntax
SQL Select Data
SQL Insert Data
SQL Update
SQL Delete Row
PHP mysqli_query()
SQL order
SQL Create Database
SQL Display Data
SQL Count()
SQL mysqli_connect
SQL create table
SQL Where And & Or
SQL like Syntax
SQL Between Operator
SQL IN Operator
Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.


CSS background color - opacity, gradient...
CSS flex - display: flex - CSS Flexbox L...
CSS border padding...
HTML text center horizontally and vertic...
HTML text input <input type="text"&g...
HTML link color...
How to Link CSS to HTML, external file n...
HTML link - hyperlink...
jQuery replace...
jQuery replaceClass...
jQuery click ()...
jQuery switchClass()...
jQuery draggable()...
jQuery HTML...
jQuery scroll smooth...
jQuery scroll()...
jQuery stop()...
jQuery animate()...
jQuery SlideToggle()...
jQuery slideDown()...