MySQL BIN() Function converts a decimal number to its binary representation, making it useful for debugging bitwise operations and analyzing data storage.
Learn how to use the MySQL BETWEEN operator to filter data based on a range of values, including numbers, dates, and strings.
MySQL BENCHMARK() Function allows you to execute an expression multiple times and measure how long it takes, helping you identify potential bottlenecks or compare different approaches.
MySQL AVG() Function calculates the average value of a numeric column, making it essential for data analysis and reporting.
MySQL ASCII() Function allows you to retrieve the numeric ASCII code of the leftmost character in a string, making it a fundamental tool for character manipulation and analysis.
MySQL AES_ENCRYPT() Function provides a straightforward way to implement robust AES-128 encryption directly in your database queries, ensuring your data remains secure at rest.
MySQL AES_DECRYPT() Function reverses the encryption performed by AES_ENCRYPT(), allowing you to securely retrieve original data when needed.
MySQL ADDTIME() Function allows you to add a time interval to a time or datetime value, making it an essential tool for time-based calculations in databases.
MySQL ADDDATE() Function allows you to add a specified time interval to a date, making it an essential tool for date manipulation in databases.
The MariaDB ST_RELATE() function is a powerful spatial function that provides detailed insights into how two geometries interact, using the Dimensionally Extended 9-Intersection Model (DE-9IM).
ST_RELATE()
The MariaDB ST_PolygonFromWKB() function is essential for converting Well-Known Binary (WKB) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.
ST_PolygonFromWKB()
The MariaDB ST_PolygonFromText() function is essential for converting Well-Known Text (WKT) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.
ST_PolygonFromText()
The MariaDB ST_PolyFromWKB() function is a powerful tool for converting Well-Known Binary (WKB) representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.
ST_PolyFromWKB()
The MariaDB ST_PolyFromText() function is a powerful tool for converting text representations of polygons into spatial data types, enabling efficient storage and analysis of geographic information.
ST_PolyFromText()
The ST_POINTONSURFACE() function is a powerful tool for obtaining a point that lies on the surface of a given geometry, whether it’s a polygon or a linestring.
The MariaDB ST_POINTN() function is a powerful tool for extracting specific points from linestring geometries, allowing for detailed spatial data analysis.
ST_POINTN()
The ST_IsRing() function in MariaDB is used to determine whether a given linestring geometry forms a closed ring.
ST_IsRing()
The ST_ISEMPTY() function in MariaDB is used to determine whether a given geometry is empty or not.
ST_ISEMPTY()
The ST_ISCLOSED() function in MariaDB is used to determine whether a given geometry is closed or not.
ST_ISCLOSED()
The ST_INTERSECTS() function in MariaDB is used to determine whether two given geometries intersect or overlap with each other.
ST_INTERSECTS()
The ST_INTERSECTION() function in MariaDB is used to calculate the geometric intersection between two geometry values.
ST_INTERSECTION()
The ST_InteriorRingN() function in MariaDB is used to retrieve the N-th interior ring of a Polygon geometry. Interior rings are the rings that define holes or inner boundaries within a polygon.
ST_InteriorRingN()
The ST_GeomFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.
ST_GeomFromWKB()
The ST_GeomFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.
ST_GeomFromText()
The ST_GEOMETRYTYPE() function in MariaDB is used to retrieve the type of a geometry value.
ST_GEOMETRYTYPE()
The ST_GEOMETRYN() function in MariaDB is used to return the N-th geometry from a collection of geometries, allowing for efficient extraction of individual geometries from collections.
ST_GEOMETRYN()
The ST_GeometryFromWKB() function in MariaDB is used to construct a geometry value from a Well-Known Binary (WKB) representation of a geometry.
ST_GeometryFromWKB()
The ST_GeometryFromText() function in MariaDB is used to construct a geometry value from a Well-Known Text (WKT) representation of a geometry.
ST_GeometryFromText()
The ST_GeometryCollectionFromWKB() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Binary (WKB) representation of a geometry collection.
ST_GeometryCollectionFromWKB()
The ST_GeometryCollectionFromText() function in MariaDB is used to construct a GeometryCollection value from a Well-Known Text (WKT) representation of a geometry.
ST_GeometryCollectionFromText()
The ST_GeomCollFromWKB() function in MariaDB is used to create a geometry collection from a Well-Known Binary (WKB) representation.
ST_GeomCollFromWKB()
The ST_GeomCollFromText() function in MariaDB is used to create a geometry collection from a Well-Known Text (WKT) representation of a geometry.
ST_GeomCollFromText()
The ST_ExteriorRing() function in MariaDB is used to retrieve the exterior ring of a polygon geometry.
ST_ExteriorRing()
The ST_EQUALS() function in MariaDB is used to determine whether two spatial objects are geometrically equal or not.
ST_EQUALS()
The ST_ENDPOINT() function in MariaDB is used to retrieve the endpoint of a linestring geometry.
ST_ENDPOINT()
The ST_ENVELOPE() function in MariaDB is used to calculate the minimum bounding rectangle (MBR) or envelope of a spatial object.
ST_ENVELOPE()
The ST_DISTANCE() function in MariaDB is used to calculate the Cartesian distance between two spatial objects.
ST_DISTANCE()
The ST_DISTANCE_SPHERE() function in MariaDB is used to calculate the minimum distance between two spatial objects on a spherical surface, considering the curvature of the Earth.
ST_DISTANCE_SPHERE()
The ST_DISJOINT() function in MariaDB is used to determine whether two spatial objects are disjoint or not. It returns 1 if the objects do not intersect or touch each other, and 0 if they do.
ST_DISJOINT()
The ST_DIMENSION() function in MariaDB is used to retrieve the dimension value of a spatial object, allowing for efficient analysis and manipulation of spatial data.
ST_DIMENSION()
The ST_Difference() function in MariaDB is used to calculate the geometric difference between two spatial objects, allowing for efficient analysis and manipulation of spatial data.
ST_Difference()
The ST_CROSSES() function in MariaDB is used to determine whether two spatial objects cross each other, allowing for efficient analysis and manipulation of spatial data.
ST_CROSSES()
The ST_ConvexHull() function in MariaDB is used to calculate the convex hull of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_ConvexHull()
The ST_Contains() function in MariaDB is used to determine whether a given geometry value contains another geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Contains()
The ST_Centroid() function in MariaDB is used to calculate the centroid of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Centroid()
The ST_BUFFER() function in MariaDB is used to create a buffer geometry around a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_BUFFER()
The ST_Boundary() function in MariaDB is used to return the boundary of a given geometry value, allowing for efficient analysis and manipulation of spatial data.
ST_Boundary()
The ST_ASWKT() function in MariaDB is used to convert a geometry value into its Well-Known Text (WKT) representation, allowing for efficient storage and retrieval of spatial data.
ST_ASWKT()
The ST_AsWKB() function in MariaDB is used to convert a geometry value into its Well-Known Binary (WKB) representation, allowing for efficient storage and transfer of spatial data.
ST_AsWKB()
The ST_PointFromWKB() function in MariaDB is used to create a point geometry from its Well-Known Binary (WKB) representation, allowing for efficient storage and retrieval of spatial data.
ST_PointFromWKB()