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 vote343 views1 answer
Mysql text to decimal
SQL
4 votes306 views3 answers
Mysql varchar length
SQL
8 votes276 views1 answer
Similarities between ddl and dml
SQL
3 votes342 views1 answer
Select count from table mysql
SQL
1 vote304 views1 answer
Show table columns
SQL
1 vote256 views1 answer
How to run sql script
SQL
0 vote329 views1 answer
Sql alter table add column if exists
SQL
1 vote362 views2 answers
Install sql server management studio ubuntu
SQL
0 vote337 views2 answers
Sql day from datetime
SQL
-1 vote352 views4 answers
Sql view postgresql
SQL