Menu

Articles

Subtract year from date value in MariaDB

This article gives an example of subtracting a year from a given date in MariaDB.

Subtract a day from a date value in MariaDB

This article gives an example of subtracting one day from a given date in MariaDB.

Show all locales in MariaDB

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

How to set named time zones in MariaDB

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

How to Set up automatic vertical output for MariaDB

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

How to get month and day name in different languages ​​in MariaDB

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

How to get the day with a suffix in MariaDB

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

Use JSON_EXTRACT function to extract elements in JSON array in MariaDB

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

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.

How to list all stored procedures in MariaDB

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