content_image/718480.jpg
SQL Modes” .) Individual client programs can request this behavior by using the CLIENT_IGNORE_SPACE  option for mysql_real_connect() . In either case, all function names become reserved words. 

For the sake of brevity, some examples in this chapter display the output from the mysql  program in abbreviated form. Rather than showing examples in this format: 

## 12.1 Built-In Function and Operator Reference 

mysql> SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) 

This format is used instead: 

mysql> SELECT MOD(29,9); -> 2 

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference” . 

<img src='content_image/718480.jpg'>

