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

0 vote159 views2 answers
Mysql row_number() example
SQL
0 vote174 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote136 views1 answer
Oracle select invalid views
SQL
3 votes145 views2 answers
See mysql users ubuntu
SQL
0 vote140 views1 answer
Find most frequent value in SQL column
SQL
0 vote138 views1 answer
Oracle last connection
SQL
0 vote108 views1 answer
Store query result in variable sql
SQL
4 votes144 views3 answers
Sqlite show columns
SQL
0 vote152 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote144 views1 answer
Oracle synonym procedure dblink
SQL