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

46 votes175 views4 answers
Create column sql
SQL
7 votes102 views6 answers
Reset identity column in sql server
SQL
-1 vote116 views2 answers
Full join sql
SQL
-1 vote101 views1 answer
How to use update trigger in sql
SQL
0 vote104 views1 answer
Show database not empty tables postgres
SQL
0 vote98 views1 answer
Sql select lowest value row
SQL
0 vote105 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote105 views1 answer
Drop df constraint sql server
SQL
3 votes112 views2 answers
Mysql update row
SQL
0 vote107 views1 answer
Sql sort ages
SQL