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, 296🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...