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 vote267 views1 answer
Check if string is a number sql
SQL
0 vote258 views1 answer
Multiple tricky query in sql server
SQL
0 vote278 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote256 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote257 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
52 votes452 views6 answers
Rename column sql
SQL
8 votes278 views1 answer
See all users mysql
SQL
0 vote268 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
-1 vote261 views1 answer
Adding a new table psql
SQL
2 votes259 views1 answer
While loop sql
SQL