MariaDB

Beyond the pattern matching available from LIKE clauses, MariaDB offers regular expression-based matching through the REGEXP operator. The operator performs pattern matching for a string expression based on a given…

When working with NULL values, remember they are unknown values. They are not empty strings or zero, which are valid values. In table creation, column specifications allow for setting them…

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…