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 vote108 views1 answer
View acl table oracle
SQL
19 votes129 views5 answers
Date between in mysql
SQL
0 vote110 views1 answer
Sql select min
SQL
1 vote117 views1 answer
PL SQL MODIFY COLUMN NME
SQL
19 votes117 views2 answers
Mysql tinyint max value
SQL
0 vote117 views1 answer
Mysqlimport
SQL
6 votes121 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote115 views1 answer
List all functions and procedures in postgres query
SQL
10 votes115 views2 answers
Sql merge statement
SQL
0 vote123 views1 answer
Second Step in installing SQL workbench
SQL