Movatterモバイル変換

CREATE [AGGREGATE] FUNCTIONfunction_name    RETURNS {STRING|INTEGER|REAL|DECIMAL}    SONAMEshared_library_name

This statement loads the loadable function namedfunction_name. (CREATE FUNCTION is also used to created stored functions; seeSection 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.)

A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL function such asABS() orCONCAT(). SeeAdding a Loadable Function.

function_name is the name that should be used in SQL statements to invoke the function. TheRETURNS clause indicates the type of the function's return value.DECIMAL is a legal value afterRETURNS, but currentlyDECIMAL functions return string values and should be written likeSTRING functions.

TheAGGREGATE keyword, if given, signifies that the function is an aggregate (group) function. An aggregate function works exactly like a native MySQL aggregate function such asSUM() orCOUNT().

shared_library_name is the base name of the shared library file containing the code that implements the function. The file must be located in the plugin directory. This directory is given by the value of theplugin_dir system variable. For more information, seeSection 5.6.1, “Installing and Uninstalling Loadable Functions”.

CREATE FUNCTION requires theINSERT privilege for themysql system database because it adds a row to themysql.func system table to register the function.

During the normal startup sequence, the server loads functions registered in themysql.func table. If the server is started with the--skip-grant-tables option, functions registered in the table are not loaded and are unavailable.