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 vote436 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
2 votes195 views1 answer
Docker run postgres locally
SQL
1 vote197 views1 answer
Change table to innodb mysql
SQL
0 vote262 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
6 votes174 views1 answer
Oracle rank() over (partition)
SQL
3 votes178 views2 answers
Postgres inner join vs join
SQL
0 vote180 views1 answer
Do postgresql
SQL
3 votes225 views2 answers
Search text in all sql server stored procedure
SQL
3 votes194 views3 answers
Mysql order by list
SQL
1 vote199 views1 answer
Mysql add fields
SQL