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 vote332 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote383 views1 answer
SQL check if record exist
SQL
1 vote398 views2 answers
Truncate table sqlite
SQL
0 vote313 views1 answer
Sql new line output
SQL
0 vote344 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote358 views1 answer
Postgresql default value boolean
SQL
3 votes380 views1 answer
Locate sql server
SQL
0 vote366 views1 answer
Sql replace id with name from another table
SQL
15 votes539 views2 answers
Sql order by alphabetical
SQL
2 votes382 views1 answer
Oracle block
SQL