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 vote168 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
2 votes188 views1 answer
How to insert string variable into sqlite database
SQL
0 vote156 views1 answer
Sql runnignsum
SQL
1 vote171 views1 answer
Jooq convert using gbk
SQL
1 vote194 views4 answers
Alter schema sql
SQL
0 vote190 views1 answer
Check connections to database postgres
SQL
1 vote177 views2 answers
How to enable error squiggles in vs code
SQL
0 vote192 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
7 votes183 views2 answers
Execute mysql file
SQL
0 vote211 views1 answer
Add user mysql wordpress
SQL