Collections:
MySQL Functions on Numeric Values
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
Here is a collection of reference information and tutorials on MySQL database functions on numeric values compiled by FYIcenter.com DBA team.
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
LOG() - Logarithm of Y to Base X
LOG10() - Logarithm to Base 10
MAKE_SET() - Filtering List with Binary Set
MOD() - Remainder of X divided by Y
POW() - X Raised to Power of Y
RADIANS() - Degrees to Radians
RAND() - Random Value Generator
ROUND() - Rounding to Decimal Place
SIN() - Sine Trigonometric Value
2023-11-14, 276🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...