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

5 votes139 views1 answer
Copy table from one database to another mysql
SQL
0 vote194 views1 answer
Mysql pv progres
SQL
1 vote174 views1 answer
Sql trigger before delete
SQL
8 votes171 views1 answer
Unique vs primary key
SQL
0 vote169 views1 answer
Sql string length postgresql
SQL
0 vote206 views1 answer
Sort by last two number sql
SQL
0 vote179 views1 answer
Sql change date format
SQL
0 vote199 views1 answer
PSQL qith variables
SQL
14 votes192 views1 answer
Oracle alter table add column not null
SQL
1 vote205 views4 answers
How to check table in postgresql from terminal
SQL