Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How to left pad numbers with zeros in MariaDB

This article discusses how to left pad numbers with zeros with the help of the LPAD() function in MariaDB.

This article discusses two methods of listing all stored procedures in MariaDB.

This article provides an example for checking that a value does not contain numberical digit in MariaDB.

This article discusses how to use the DATE_FORMAT() function get the month name from the specified date in MariaDB.

This article discusses how to get the end day of a month using the LAST_DAY() function In MariaDB.

This article discusses how to get the day name from a specified date using the DATE_FORMAT() function.

This article discusses how to use the RAND() function to generate random numbers in MariaDB.

This article discusses how to check if a string field contains a number in MariaDB.

This article discusses ways to format numbers in MariaDB.

This article gives several ways to add AM/PM to time values in MariaDB.