Home / Funtions and Operators
Here you can find categories of functions and operators those are available in MySQL alongwith examples that show how to use several of them.
Functions can be invoked within expressions and return a value that is used in place of the function call when the expression is evaluated. When you invoke a function, there must be no space after the function name and before the opening parenthesis. It's possible to change this default behavior by enabling the IGNORE_SPACE SQL mode to cause spaces after the function name to be ignored. Take examples below:
mysql> SELECT PI ();
ERROR 1305 (42000): FUNCTION world.PI does not exist
mysql> SET sql_mode = 'IGNORE_SPACE';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT PI ();
+----------+
| PI () |
+----------+
| 3.141593 |
+----------+
1 row in set (0.00 sec)
Funtions and Operators Related FAQs
|