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 vote58 views2 answers
On delete set default sql server
SQL
25 votes91 views1 answer
Mysql grant all privileges to a user
SQL
7 votes110 views3 answers
Select latest entry in sql table
SQL
0 vote116 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote99 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote127 views1 answer
Sql tablo sp
SQL
0 vote97 views1 answer
Truncate table sql server foreign key
SQL
1 vote131 views1 answer
Sql server loop over query
SQL
0 vote122 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote103 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL