Numeric Functions
A function is a MySQL command used in an SQL statement that takes one or more arguments and returns a value based on the values supplied. Just as with expressions, you can use a function anywhere a fixed value could otherwise be used, or to manipulate the value returned in a database column.
Case Sensitivity
Function names are not case sensitive in MySQL. For example, you can use ROUND(), Round(), or round()—these all perform the same function call. |
Arguments
To pass a function more than one argument, separate the values in parentheses ... |
Get Sams Teach Yourself MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.