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 vote214 views2 answers
Plsql regex match whole word
SQL
1 vote215 views1 answer
Alter constraint postgres
SQL
0 vote227 views1 answer
Hotw to alter lengh character vayng postgres
SQL
10 votes206 views3 answers
Sql limit results
SQL
2 votes252 views1 answer
Datefromparts mssql
SQL
1 vote209 views1 answer
Update and replace mysql
SQL
1 vote227 views3 answers
How to truncate foreign key constraint table
SQL
0 vote268 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
11 votes211 views2 answers
MySQL DISTINCT
SQL
0 vote221 views1 answer
Database traccar
SQL