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

-1 vote218 views1 answer
How to open blade file from blade in laravel
SQL
35 votes251 views5 answers
Sql alter column
SQL
2 votes229 views4 answers
List databases in sql server
SQL
4 votes232 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote228 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote316 views2 answers
Sqlalchemy default value for column
SQL
0 vote241 views1 answer
Sql pivot table
SQL
3 votes218 views1 answer
Oracle get trigger ddl
SQL
0 vote214 views1 answer
How to get all values in a table mysql in c#
SQL
4 votes219 views3 answers
Order by value mysql
SQL