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

3 votes207 views2 answers
Postgresql remove not null constraint
SQL
3 votes214 views4 answers
Psql list tables in schema
SQL
3 votes215 views2 answers
Mysql import gz
SQL
2 votes202 views1 answer
Oracle trace file
SQL
0 vote214 views1 answer
Mysql multiple primary keys
SQL
0 vote205 views1 answer
Sql waitfor
SQL
0 vote202 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote197 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote230 views2 answers
Insert data mysql with cmd
SQL
-1 vote152 views1 answer
Mysql how to set update or create
SQL