<< < 11 12 13 14 15 16   ∑:380  Sort:Date

CONNECTION_ID() - Thread ID of Current Connection
How to obtain the connection ID of the current connection using the CONNECTION_ID() function? CONNECTION_ID() is a MySQL built-in function that returns the connection ID of the current connection. The connection ID is also referred as thread ID or process ID. For example: SELECT CONNECTION_ID(); -- ...
2024-07-15, 1355🔥, 0💬

UUID() - Generating UUID String
How to generate a UUID (Universal Unique IDentifier) string using the UUID() function? UUID() is a MySQL built-in function that returns a UUID (Universal Unique IDentifier) string. For example: SELECT UUID(), UUID(); -- +----------------------------- ---------+-------------------- ------------------+...
2023-12-08, 1344🔥, 0💬

VAR_SAMP() - Sample Standard Variance
How to calculate the sample standard variance of a field expression in result set groups using the VAR_SAMP() function? VAR_SAMP(expr) is a MySQL built-in aggregate function that calculates the sample standard variance of a field expression in result set groups. For example: SELECT help_category_id,...
2023-12-01, 1336🔥, 0💬

YEARWEEK() - Year Week Combination
How to calculate the year week combination from a given date using the YEARWEEK() function? YEARWEEK(date, mode) is a MySQL built-in function that calculates the year week combination from a given date. For example: SELECT YEARWEEK('2024-03-04'), WEEK('2024-03-04'); -- +------------------------+---- ...
2023-11-16, 1325🔥, 0💬

SUM() - Total Value in Group
How to calculate the total value of a field expression in result set groups using the SUM() function? SUM(expr) is a MySQL built-in aggregate function that calculates the total value of a field expression in result set groups. For example: SELECT help_category_id, SUM(help_topic_id), COUNT(help_topi...
2023-12-01, 1319🔥, 0💬

NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function? NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+-----. ..
2023-12-19, 1313🔥, 0💬

IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
How to detect an IPv6 Address that is IPv4 compatible using the IS_IPV4_COMPAT() function? IS_IPV4_COMPAT(ip) is a MySQL built-in function that returns 1 if the given IPv6 address is IPv4-compatible, 0 otherwise. The IPv6 address must be given in number format. An IPv4-compatible IPv6 address has 12...
2026-02-02, 1310🔥, 0💬

VAR_POP() - Population Standard Variance
How to calculate the population standard variance of a field expression in result set groups using the VAR_POP() function? VAR_POP(expr) is a MySQL built-in aggregate function that calculates the population standard variance of a field expression in result set groups. For example: SELECT help_catego...
2023-12-01, 1290🔥, 0💬

EXPORT_SET() - Exporting Binary Set to On/Off Flags
How to export an integer as a binary set to on/off flags using the EXPORT_SET() function? EXPORT_SET(bits, on, off, delimiter, len) is a MySQL built-in function that converts an integer as a binary set (a sequence of bits) to on/off flags. It loops through every bit of the given integer "bits" start...
2023-12-20, 1282🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)...
2024-11-23, 1281🔥, 0💬

TRUNCATE() - Truncating to Decimal Place
How to truncate a value to a given decimal place using the TRUNCATE() function? TRUNCATE(X, D) is a MySQL built-in function that truncates X to decimal place of D. For example: SELECT TRUNCATE(-1.58, 0), TRUNCATE(23.298, 1), TRUNCATE(23.298, -1); -- +--------------------+-------- -------------+------...
2023-11-14, 1280🔥, 0💬

ROW_NUMBER() - Row Position in Result Set Window
How to obtain the row position of the current row in the current result set window using the ROW_NUMBER() function? ROW_NUMBER(n) is a MySQL built-in window function that returns the row position of the current row in the current result set window. For example: SELECT help_topic_id AS tic, help_cate...
2024-09-12, 1269🔥, 0💬

UPPER() - Convert String to Upper Case
How to convert a string to upper case using the UPPER() function? UPPER(str) is a MySQL built-in function that converts all characters of a given into upper case characters. For example: SET @str = 'dba.FYIcenter.com'; SELECT UPPER(@str); -- +-------------------+ -- | UPPER(@str) | -- +-------------...
2023-11-13, 1256🔥, 0💬

VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"
How to obtain the inserting value of given column in the "ON DUPLICATE KEY UPDATE" clause using the VALUES() function? VALUES(col) is a MySQL built-in function that returns the inserting value of a given column and use it in the "ON DUPLICATE KEY UPDATE" clause. For example: CREATE TABLE MyTable (id...
2025-10-24, 1245🔥, 0💬

IS_USED_LOCK() - Checking Lock Owner
How to check the owner of a user defined lock using the IS_USED_LOCK() function? IS_USED_LOCK(lock) is a MySQL built-in function that returns the connection id the lock associated with if the lock is in use, NULL otherwise. For example: SELECT GET_LOCK('MyLock', 60), IS_USED_LOCK('MyLock'); -- +----...
2023-12-20, 1225🔥, 0💬

TAN() - Tangent Trigonometric Value
How to calculate the tangent trigonometric value of a given angle using the TAN() function? TAN(X) is a MySQL built-in function that calculates the tangent trigonometric value of a given angle in radians. For example: SELECT TAN(0.1), TAN(1.57), TAN(3.14); -- +---------------------+------- ----------...
2023-11-14, 1191🔥, 0💬

PERCENT_RANK() - Rank Percentage of Sorted Values
How to calculate the rank percentage of the sorting field expression in the current result set window using the PERCENT_RANK() function? PERCENT_RANK(n) is a MySQL built-in window function that calculates the rank percentage of the sorting field expression in the current result set window. For examp...
2024-09-12, 1166🔥, 0💬

IS_FREE_LOCK() - Checking Lock Status
How to check the status of a user defined lock using the IS_FREE_LOCK() function? IS_FREE_LOCK(lock) is a MySQL built-in function that returns 1 if a given user lock is free, 0 otherwise. For example: SELECT GET_LOCK('MyLock', 60), IS_FREE_LOCK('MyLock'); -- +------------------------+---- -----------...
2023-12-20, 1166🔥, 0💬

COALESCE() - Finding First Non-NULL Value
How to find the first non-NULL value from a list using the COALESCE() function? COALESCE(val1, val2, ...) is a MySQL built-in function that returns the first non-NULL value from a given list of values. For example: SELECT COALESCE(NULL, 'FYI', NULL, 3.14); -- +----------------------------- ------+--...
2026-03-22, 1064🔥, 0💬

CAST() - Casting Expression to Value
How to cast an expression to a value of the given data type using the CAST() function? CAST(exp AS type) is a MySQL built-in function that casts an expression to a value of the given data type. For example: SET @exp = '-1.99 USD'; SELECT @exp, CAST(@exp AS SIGNED INTEGER), CAST(@exp AS UNSIGNED INTE...
2026-03-22, 1017🔥, 0💬

<< < 11 12 13 14 15 16   ∑:380  Sort:Date