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, 327🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...