Manage Database in MySQL

Before doing anything else with the data, you need to create a database. A database is a container of data. It stores contacts, vendors, customers or any kind of data that you can think of.

In MySQL, a database is a collection of objects that are used to store and manipulate data such as tables, database views, triggers, and stored procedures.

To create a database in MySQL, you use the CREATE DATABASE  statement as follows:

CREATE DATABASE [IF NOT EXISTS] database_name;
Let’s examine the CREATE DATABASE  statement in greater detail:

Followed by the CREATE DATABASE  statement is database name that you want to create. It is recommended that the database name should be as meaningful and descriptive as possible.
The IF NOT EXISTS  is an optional clause of the statement. The IF NOT EXISTS clause prevents you from an error of creating a new database that already exists in the database server. You cannot have 2 databases with the same name in a MySQL database server.

Source: mysqltutorial.org

Similar codes

0 vote176 views1 answer
How to create a new shema using query languaage
SQL
0 vote170 views1 answer
Postgresql comandos basicos
SQL
0 vote231 views2 answers
Getting customers with no orders sql
SQL
1 vote211 views1 answer
Continue in sql
SQL
0 vote152 views1 answer
Mariadb set vertical output format
SQL
0 vote201 views1 answer
Postgresql create table default value timestamp
SQL
6 votes181 views2 answers
Mysqldump password in file
SQL
13 votes162 views6 answers
Mysql update from select
SQL
0 vote187 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
-1 vote173 views1 answer
What is in operator
SQL