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

3 votes189 views2 answers
@sqlresultsetmapping
SQL
3 votes154 views2 answers
Mysql HAVING
SQL
6 votes142 views2 answers
Mysql version check cmd
SQL
3 votes167 views1 answer
Postgres select max value
SQL
1 vote374 views1 answer
How to make a select in sql
SQL
2 votes171 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote181 views1 answer
Sql today at midnight
SQL
5 votes159 views1 answer
Commentaire table oracle
SQL
0 vote150 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote149 views1 answer
Mysql search multiple tables
SQL