Datatabase

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

MariaDB MIN() Function MariaDB MIN() functiuon is used to retrieve the minimum value of the expression. Syntax: SELECT MIN(aggregate_expression) FROM tables [WHERE…

MariaDB ORDER BY Clause In MariaDB database, ORDER BY Clause is used to sort the records in your result set in ascending…

MariaDB Procedure MariaDB procedure is a stored program that is used to pass parameters into it. It does not return a value…

MariaDB Regular Expressions MariaDB provides regular expression based matching through the REGEXP Operator. Syntax: expression REGEXP pattern Parameter Explanation: expression: A character…

MariaDB RIGHT OUTER JOIN MariaDB RIGHT OUTER JOIN is used to return all rows from right-hand table specified in the ON condition…

SELECT Database USE database command is used to select the database, you want to use and create table within it. Syntax: USE…

MatiaDB SELECT Limit In MariaDB database, SELECT statement is used with LIMIT clause to retrieve one or more records from a table.…

Select Data SELECT statement is used to retrieve records from single or multiple tables. Syntax: SELECT expressions FROM tables [WHERE conditions]; The…

MariaDB SUM Function MariaDB SUM function is used to return the summed value of an expression. Syntax: SELECT SUM(aggregate_expression) FROM tables [WHERE…