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 vote192 views1 answer
Select users with same username
SQL
0 vote187 views1 answer
Mysql command prompt date insert format
SQL
0 vote260 views1 answer
Selecting specific day in colum sql
SQL
0 vote201 views1 answer
Mysql replication change database name
SQL
15 votes218 views4 answers
Sql update from select
SQL
0 vote185 views1 answer
Sql shell psql cannot enter password
SQL
1 vote191 views3 answers
Sql union
SQL
0 vote226 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote3.7K views1 answer
PSQL use LIKE with timestamps
SQL
0 vote190 views1 answer
Mysql server not running
SQL