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 vote285 views1 answer
How to close external sql connection in laravel
SQL
0 vote266 views1 answer
How many columns can be used for creating index?
SQL
4 votes282 views2 answers
Bulk kill mysql processlist
SQL
12 votes263 views4 answers
SQL Where
SQL
9 votes270 views1 answer
Identity insert on sql server
SQL
0 vote289 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote264 views1 answer
Selects all the columns from the sailors table
SQL
-1 vote287 views3 answers
SQL to LINQ converter
SQL
0 vote290 views1 answer
How to move a column to different spot mysql
SQL
1 vote280 views1 answer
Change table to innodb mysql
SQL