MariaDB SELECT To retrieve records from a table or multiple tables stored in a database, the MariaDB SELECT statement is used. Syntax: To select all fields from a table. SELECT * FROM table_name; Example: Selecting all fields from a table. SELECT * FROM Players;SELECT * FROM Players; Output: ID NAME SPORTS 1 Sachin Cricket 2 … Read more

MariaDB Comparison Operator To test the equality and inequality, as well as other advanced comparing operations, MongoDB Comparison Operators are used. MariaDB supports the following comparison operators.   OPERATOR USES = equal <=> equal (safe to compare null values) <> not equal != not equal > greater than >= greater than or equal < less … Read more

MariaDB INSERT The MariaDB INSERT INTO statement is used to insert records into a table. Syntax: INSERT into table_name(column_1, column_2, … column_n ) VALUES(value1, value2, .. valuen); Example 1: Single record insertion: Players table before insertion: ID NAME SPORTS 1 Sachin Cricket 2 Dhoni Cricket INSERT INTO Players (id, name, sports) VALUES (3, ‘Sunil’, ‘Football’);INSERT … Read more

CREATE TABLE After creating a database in MariaDB, one can create a new table in the selected database using the MariaDB CREATE TABLE statement. Syntax 1: To create a Table in MariaDB. CREATE TABLE table_name ( column_name data_type column_constraint ); Syntax 2: To check all the existing Tables in a database. SHOW tables; Example 1: … Read more

DROP TABLE To drop a table permanently (with no option for the recovery of the table) from a MariaDB database, the MariaDB DROP TABLE statement is used. Syntax: DROP TABLE table_name; Example: DROP TABLE players;DROP TABLE players; Explanation: The “players” is an already existing table. The selected table will be deleted permanently from the database … Read more

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