Articles

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

MariaDB SHA() Function

Learn that MariaDB SHA() is an alias for SHA1(), returns a 40-character hexadecimal digest, and is not suitable for password storage.

How the IsSimple() function works in Mariadb?

The MariaDB IsSimple() function is used to verify that a given geometry does not have any anomalous geometric points, such as self-intersections or complex loops.

How the LENGTH() function works in Mariadb?

The LENGTH() function is a string function that returns the length of a given string in bytes.

How the SETVAL() function works in Mariadb?

The SETVAL() function in MariaDB is used to set the sequence counter for a specified sequence object to a specific value.

MariaDB MD5() Function

Learn MariaDB MD5() syntax, its 32-character checksum result, NULL behavior, and why it is not suitable for passwords or encryption.

How the IsRing() function works in Mariadb?

The MariaDB IsRing() function is used to assess whether a given LINESTRING is a ring.

How the LEFT() function works in Mariadb?

The LEFT() function is a string function that returns the leftmost part of a given string, up to a specified number of characters.

How the MBRWithin() function works in Mariadb?

The MBRWithin() function is a useful tool for performing spatial queries in Mariadb.

MariaDB SESSION_USER(): Version Behavior and Examples

Learn how MariaDB SESSION_USER() behaves across versions, how it relates to USER() and CURRENT_USER(), and how to compare session identities.

How the ISNULL() function works in Mariadb?

The MariaDB ISNULL() function is used to determine if a specified expression is NULL.