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

16 votes289 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote280 views1 answer
Sql select where more than one record exists
SQL
2 votes296 views1 answer
Dbms transaction (psql)
SQL
0 vote269 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
1 vote283 views1 answer
Create another table from existing table sql oracle
SQL
7 votes274 views2 answers
Execute mysql file
SQL
14 votes269 views3 answers
SQL trim
SQL
0 vote305 views1 answer
Drop view in mysql
SQL
0 vote255 views1 answer
Psql no such file or directory
SQL
0 vote272 views1 answer
Procedures sql insert mysql
SQL