Selecting a Database
Now for selecting a database for your project in MariaDB, we will use the USE command.
Query:
USE students;
Explanation: The students database has been selected. Now we can create tables, insert data and perform queries in this database.
MariaDB Select Datatabase
MariaDB is one of the most powerful relational database management systems(RDBMS) which offers a robust set of SQL commands for effective data manipulation. It is free and open-source software. It is used for various purposes like data warehousing, e-commerce, and logging applications.
We typically switch between databases using the USE command. We are using HeidiSQL software which is free and has the aim to be easy to learn. “Heidi” lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL, and SQLite.
In this article, we will see, how to select a particular database for further processes like creating tables or writing queries.