Collections:
MySQL Functions for Miscellaneous Purposes
Where to find reference information and tutorials on MySQL database functions for Miscellaneous Purposes? I want to know how to use CAST(), SLEEP() and other miscellaneous functions.
✍: FYIcenter.com
Here is a collection of reference information and tutorials on MySQL database functions for Miscellaneous Purposes compiled by FYIcenter.com DBA team.
CAST() - Casting Expression to Value
COALESCE() - Finding First Non-NULL Value
CONVERT() - Character Set Conversion
DEFAULT() - Table Column Default Value
EXTRACTVALUE() - Extracting Text Content from XML
GET_LOCK() - Requesting User Defined Lock
GREATEST() - Finding the Greatest/Maximum Value
IF() - Conditional Value Selection
IFNULL() - Replacing NULL Value
INET_ATON() - IP Address String to Number
INET_NTOA() - IP Address Number to String
INET6_ATON() - IPv6 Address String to Number
INET6_NTOA() - IPv6 Address Number to String
IS_FREE_LOCK() - Checking Lock Status
IS_IPV4() - Detecting IPv4 Address
IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address
IS_IPV6() - Detecting IPv6 Address
IS_USED_LOCK() - Checking Lock Owner
ISNULL() - Detecting NULL Value
LEAST() - Finding the Least/Minimum Value
NAME_CONST() - PS Thread ID of Given Connect
NULLIF() - NULL on Equal Values
RELEASE_ALL_LOCKS() - Release All Locks
RELEASE_LOCK() - Release Lock Instance
SLEEP() - Holding Statement Execution
⇒ CAST() - Casting Expression to Value
2023-12-19, 278🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...