MySQL Functions on Numeric Values

Q

Where to find reference information and tutorials on MySQL database functions on numeric values? I want to know how to use ABS(), ROUND() and other numeric value functions.

✍: FYIcenter.com

A

Here is a collection of reference information and tutorials on MySQL database functions on numeric values compiled by FYIcenter.com DBA team.

ABS() - Absolute Value

ACOS() - Arccosine Trigonometric Value

ASIN() - Arcsine Trigonometric Value

ATAN() - Arctangent Trigonometric Value

ATAN2() - 2-Argument Arctangent

BIN() - Converting Integer to Binary String

BIT_COUNT() - Counting '1' in Binary String

CEIL() - Synonym for CEILING()

CEILING() - Rounding up to Integer

CONV() - Number Base Conversion

COS() - Cosine Trigonometric Value

COT() - Cotangent Trigonometric Value

DEGREES() - Radians to Degrees

FLOOR() - Flooring a Numeric Value

FORMAT() - Formatting Number to String

FORMAT_BYTES() - Formatting Bytes in Readable Units

EXP() - Exponential Based on E

EXPORT_SET() - Exporting Binary Set to On/Off Flags

INTERVAL() - Interval Position of Sorted List

LN() - Natural Logarithm

LOG() - Logarithm of Y to Base X

LOG10() - Logarithm to Base 10

LOG2() - Logarithm to Base 2

MAKE_SET() - Filtering List with Binary Set

MOD() - Remainder of X divided by Y

PI() - Value of PI, π

POW() - X Raised to Power of Y

POWER() - Synonym for POW()

RADIANS() - Degrees to Radians

RAND() - Random Value Generator

ROUND() - Rounding to Decimal Place

SIGN() - Sign of a Number

SIN() - Sine Trigonometric Value

SQRT() - Square Root of X

TAN() - Tangent Trigonometric Value

TRUNCATE() - Truncating to Decimal Place

⇒ ABS() - Absolute Value

⇐ WEIGHT_STRING() - String Sorting Weight

⇑⇑ MySQL Function References

2023-11-14, 1613🔥, 0💬

dba.FYIcenter.com Links
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutorials Transact-SQL Tutorials DBA Articles Site Map Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Re... 2025-03-17, 7790🔥, 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, 3382🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 2584🔥, 0💬

MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 1993🔥, 0💬

Calling MySQL Built-in Functions
Where to find answers to frequently asked questions about calling MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about calling MySQL Built-in Functions: Function Name Case Insensitive Function Argument Modifier Variable Number ... 2023-11-14, 1753🔥, 0💬

SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function? SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example: SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+-------- -+--------------------+-- | SQRT(2) | SQRT(4) | SQRT(... 2023-11-14, 1526🔥, 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, 1465🔥, 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, 1437🔥, 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, 1418🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.