DROP DATABASE To drop, eliminate, delete or remove a particular MariaDB database, from multiple available databases, the DROP database command is used. Syntax: DROP DATABASE name;DROP DATABASE name; Parameters: name: It is used to specify the name of the database to be dropped. Example: DROP DATABASE students;DROP DATABASE students; Explanation: The ‘students’ database will be … Read more
SELECT DATABASE To select a particular MariaDB database, from multiple available databases, the USE database command is used. Syntax: USE name;USE name; Parameters: name: It is used to specify the name of the database to be selected. Example: USE students;USE students; Explanation: The ‘students’ database will be selected.
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;CREATE DATABASE name; Parameters: name: It is used to specify the name of the database to be created. Example: … Read more
MariaDB Data Types A data type represents the type of the data that can be stored and processed. Some common data types include integer, floating point, string, boolean, etc. A data type also specifies the type of operations that can be performed on that type. MariaDB supports a lot of the standard data types of … Read more
MariaDB Installation To install MariaDB database on Windows Operating System, follow the below steps. Step 1: Download MariaDB for Windows from the link https://mariadb.org/download/. Step 2: RUN the downloaded file. Step 3: Click on the NEXT button in the setup Wizard. Step 4: Read the license agreement and then again click on the NEXT … Read more