Creating and deleting databases
When writing SQL queries, we actively use tables. The tables themselves are stored within specific databases, which will be discussed in this article.
Database creation has the following syntax:
CREATE DATABASE database_name;
You can use combinations of letters, numbers, and the characters "_" and "$" as the name for the database. The name can start with numbers, but it cannot consist only of them. The maximum name length is 64 characters.
You can control the creation of the database using the SHOW DATABASES operator.
Note that the SHOW DATABASES operator displays service tables in addition to user tables.
Deleting a database is done using the DROP DATABASE operator:
DROP DATABASE database_name;
The IF [NOT] EXIST construction
When creating a database or deleting it, an error may occur that a database with such name already exists (on creation) or, conversely, this database does not exist (on deletion). For such cases, there is a construction IF [NOT] EXIST.
That is, if we want to create a database only on the condition that it does not exist yet, then we use following syntax:
CREATE DATABASE IF NOT EXIST database_name;
If we want to delete the database only if it exists, then we use following syntax:
DROP DATABASE IF EXIST database_name;
Creating and deleting tables