mariadb tutorial

MariaDB DELETE Data The MariaDB DELETE statement is used to delete one or more records from the table in MariaDB database. Syntax:…

MariaDB DISTINCT Clause MariaDB DISTINCT Clause is used to remove duplicates from the result when we use it with SELECT statement. Syntax:…

Drop Database DROP DATABASE command is used to drop the database you had created. Syntax: DROP DATABASE Database_name; Example: In the previous…

DROP Table In MariaDB, DROP TABLE statement is used to drop a table from a database. It deletes the tables permanently and…

Features of MariaDB MariaDB provides the same features of MySQL with some extensions. It is relatively new and advance. Following is a…

MariaDB Joins In MariaDB database, JOINS are used to retrieve data from multiple tables. It is performed when we have two or…

MariaDB Insert Data In MariaDB, INSERT INTO statement is used to insert data in a selected table. Syntax: INSERT INTO tablename (field,field2,…)…

MariaDB Installation To perform any operation in MariaDB database, you need to install MariaDB database. To install MariaDB database on Windows Operating…

MariaDB INTERSECT Operator INTERSECT Operator is used to return intersection of 2 or more tables. If a record exists in both tables,…

MariaDB AVG() Function MariaDB AVG() function is used to retrieve the average value of an expression. Syntax: SELECT AVG(aggregate_expression) FROM tables [WHERE…