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 vote349 views3 answers
SQL to LINQ converter
SQL
0 vote359 views1 answer
Multiple replace value mssql
SQL
0 vote339 views1 answer
Sql offfset
SQL
0 vote326 views1 answer
Alter precision
SQL
2 votes324 views1 answer
Sqlite show table indexes
SQL
0 vote356 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote346 views1 answer
How to input data as id in database sql c#
SQL
12 votes351 views1 answer
Docker mysql random root password
SQL
1 vote361 views1 answer
Postgresql create table with timestamp
SQL
1 vote357 views1 answer
How to start with sql
SQL