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, 290🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...