Selecting Database with USE Command
After creating a database, We want to switch our focus to it for subsequent operations such as table creation, data insertion, and queries. The USE command facilitates this transition:
Syntax:
USE YourDatabaseName;
Query:
USE Products;
Explanation: When we will run this command, It ensure that in the MariaDB we want to USE the Products Databse to perform various operations.
MariaDB Create Database
MariaDB is a strong and adaptable relational database management system that retains a wide range of features, including efficient data manipulation. An essential element of database management is the creation of databases, which form the foundation for data organization and storage.
In this article, we will consider the procedure of construction of a database management system in MariaDB, We will consider the syntax, basic commands, and good practices concerning the construction of databases in MariaDB.
CREATE DATABASE Command
To start building a new database in MariaDB, the CREATE DATABASE statement is used. This statement allows users to start building a database with the help of a given name.
Syntax:
CREATE DATABASE YourDatabaseName;
Explanation: Use the desired name for the database instead of ”YourDatabaseName”.