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…

MariaDB Export Export a MariaDB database using HeidiSQL We have a database named “tutoraspire”, having some tables within it. Right click on…

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

MariaDB Functions MariaDB function is a stored program that is used to pass parameters into them and return a value. We can…

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

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

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