CREATE DATABASE
To create a MariaDB database, open MariaDB installed in your computer. Here you will have to write the already set password. Now the next step is the creation of the database.
Syntax:
CREATE DATABASE name; |
Parameters:
name: It is used to specify the name of the database to be created.
Example:
CREATE DATABASE students; |
Explanation:
A new database will be created with the name ‘students’. In order to check all the created database, below query, should be executed.
SHOW DATABASES; |