Articles

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

Show all locales in MariaDB

This article describes the method used to display all regional locales in MariaDB.

This article describes the steps to set up named time zones in MariaDB.

This article discusses how to set the MariaDB command-line client to automatically verticle output.

This article describes how to use the DATE_FORMAT()function return the month and week name in a given language.

This article describes how to return date numbers with suffixes in MariaDB.

This article describes how to use the JSON_EXTRACT function extract elements in a JSON array.

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.