MariaDB DELETE Data The MariaDB DELETE statement is used to delete one or more records from the table in MariaDB database. Syntax:…
Tag:
Datatabase
-
-
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,…)…