CREATE DATABASE statement

ByMisterFoxOnline

Mar 9, 2023 #CREATE DATABASE, #MySQL tutorial, #MySQL Workbench tutorial, #SQL

What would seem like a complex task — creating a new database — is possibly the simplest statement of all!

In this tutorial:

Syntax
Example
Next step

Syntax

The syntax is extremely simple:

CREATE DATABASE `databasename`;

Naming conventions for databases vary. Stick to a short, simple, descriptive name consisting of lowercase letters only and you can’t go wrong.

Example

We will use MySQL Workbench to create our new database with the following statement:

CREATE DATABASE `dbtest`;

Select the Query window
Type the following SQL statement: CREATE DATABASE dbtest;
Click the Execute button
The result displayed in the Output panel
Click the Refresh button
The new database, dbtest, appears in the Navigator panel

Next step

To add a user with some privileges to your new database, see the CREATE USER & GRANT PRIVILEGES in MySQL tutorial.

References:

W3schools. (2023). SQL CREATE DATABASE Statement. Available at: https://www.w3schools.com/sql/sql_create_db.asp (Accessed: 25 February 2023).

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Microsoft Windows MySQL PHP

CREATE DATABASE statement

ByMisterFoxOnline

Syntax

Example

Next step

References:

By MisterFoxOnline

Related Post

WAMP (& LAMP)

DROP DATABASE statement

CREATE USER & GRANT PRIVILEGES in MySQL

Leave a ReplyCancel reply