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

12 votes177 views4 answers
Mysql get date difference in hours
SQL
0 vote183 views1 answer
Sql server get date of previous sunday
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
1 vote180 views3 answers
Sql select only time from datetime
SQL
0 vote153 views2 answers
Change database postgres
SQL
1 vote169 views1 answer
How to between in sql
SQL
0 vote163 views1 answer
How to retrive the today date sql
SQL
0 vote200 views1 answer
Implode in sql query
SQL
1 vote173 views1 answer
Sql server update column based on another table
SQL
21 votes183 views6 answers
Update sql
SQL