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

2 votes356 views1 answer
Postgresql create table as select
SQL
0 vote332 views1 answer
Mysql in clausule string array
SQL
3 votes305 views1 answer
Sql select all
SQL
0 vote333 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote317 views1 answer
Oracle search columns in schema
SQL
0 vote350 views1 answer
Select sql in descending order
SQL
10 votes338 views3 answers
Join multiple tables sql
SQL
7 votes317 views1 answer
Safe mode mysql
SQL
1 vote334 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote367 views2 answers
How to truncate all table in mysql workbench
SQL