Functions can return string, integer, or real values.

You can define simple functions that operate on a single row at a time, or aggregate functions that operate on groups of rows.

Information is provided to functions that enables them to check the number and types of the arguments passed to them.

You can tell MySQL to coerce arguments to a given type before passing them to a function.

You can indicate that a function returns NULL or that an error occurred.