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 vote97 views1 answer
Sql injection mitigation
SQL
0 vote153 views1 answer
Example of sql querry result sepapreted by comma
SQL
2 votes116 views1 answer
Oracle sql concatenate results into string
SQL
0 vote130 views1 answer
Rename constraint postgresql
SQL
0 vote141 views2 answers
Update query with between in mysql
SQL
0 vote147 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote182 views2 answers
Mysql cast to varchar
SQL
0 vote131 views1 answer
Sql include rows with 0 values
SQL
8 votes151 views1 answer
My sql version
SQL
0 vote127 views1 answer
Select last 2 characters sql
SQL