If you need to find the character sets that are available in your MariaDB installation, check out the following two methods.
MariaDB
2 Ways to Return the ASCII Code for a Given Character in MariaDB
MariaDB includes two built-in functions that allow us to get the ASCII code from a given character.
4 Ways to Check a Column’s Data Type in MariaDB
MariaDB provides multiple ways of returning the data type of a column. Here are four ways to get the data type of a given column in MariaDB.
Subtract Seconds from a Datetime Value in MariaDB
Here are some options for subtracting one or more seconds from a datetime expression in MariaDB.
How to List all Stored Procedures in MariaDB
In MariaDB, we can use the SHOW PROCEDURE STATUS command to return a list of stored procedures.
We can also query the information_schema.routines table to do the same thing.
Return Random Rows from a Table in MariaDB
Here’s a quick way to return random rows from a table in MariaDB.
How to Format Numbers with Commas in SQL
Most of the major RDBMSs have functions that enable us to format numbers with commas as either the group separator, or the decimal separator.
Some RDBMSs also output certain numeric data types with commas in the relevant place.
Below are examples of formatting numbers with commas in some of the more popular DBMSs.
DROP TABLE IF EXISTS in MariaDB
In MariaDB, we can use the IF EXISTS clause of the DROP TABLE statement to check whether the table exists or not before dropping it.