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

7 votes301 views2 answers
Sql empty table
SQL
0 vote278 views1 answer
Mysql begin statement
SQL
10 votes325 views2 answers
Doublon sql
SQL
0 vote311 views1 answer
Sql sum show 0 result
SQL
0 vote276 views1 answer
How to count with except in psql
SQL
1 vote309 views2 answers
Get table column names sql laravel
SQL
79 votes561 views6 answers
Grepper code
SQL
0 vote293 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote281 views1 answer
How to check default value of column in sql server
SQL
5 votes308 views2 answers
Create table mysql example auto_increment
SQL