Get data the way you want

In previous discussions and examples, we examined retrieving from a single table, or retrieving multiple values from multiple sources. Most real-world data operations are much more complex, requiring aggregation, comparison,…

The ORDER BY clause, as mentioned in previous discussions, sorts the results of a statement. It specifies the order of the data operated on and includes the option to sort in ascending…

In this topic, we will discuss the Like Clause in MariaDB.It provides a way to retrieve data when an operator uses an exact match. In situations requiring multiple results with…

The DELETE command deletes table rows from the specified table, and returns the quantity deleted. Access the quantity deleted with the ROW_COUNT() function. A WHERE clause specifies rows and in…

Update Query in MariaDB command modifies existing fields by changing values. It uses the SET clause to specify columns for modification and to specify the new values assigned. These values…

Where Clause filters various statements such as SELECT, UPDATE, DELETE, and INSERT. They present criteria used to specify action. They typically appear after a table name in a statement, and…

In this topic, we will discuss the Select Query in MariaDB. SELECT statements retrieve selected rows. They can include UNION statements, an ordering clause, a LIMIT clause, a WHERE clause,…

MariaDB Aggregate Functions In this topic, we will discuss the useful functions of MariaDB. Most frequently used aggregate functions are given below − Sr.NoName & Description1COUNTIt counts the number of…

Backup Loading Methods means Restoring a database from a backup is a simple and sometimes terribly long process. There are three options in loading data: the LOAD DATA statement, mysqlimport,…

Creation or deletion of databases in MariaDB requires privileges, typically, only given to root users or admins. Under these accounts, you have two options for deleting a database: the mysqladmin…