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 votes277 views1 answer
Ssh check mysql version
SQL
4 votes345 views2 answers
Sql display today's date
SQL
0 vote309 views2 answers
Port 5432 is already in use mac
SQL
1 vote266 views1 answer
Primary key reset in SQL database
SQL
0 vote261 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
18 votes238 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote307 views1 answer
Sql quary intervewi question
SQL
0 vote264 views1 answer
Sql query with date
SQL
13 votes290 views2 answers
Get tables in database sql
SQL
-1 vote273 views3 answers
Error mysql shutdown unexpectedly
SQL