Rechercher dans le manuel MySQL
5.7.1 Installing and Uninstalling User-Defined Functions
User-defined functions (UDFs) must be loaded into the server before they can be used. MySQL supports UDF loading at runtime.
To load a UDF, use the CREATE
FUNCTION
statement. For example:
The UDF file base name depends on your platform. Common suffixes
are .so
for Unix and Unix-like systems,
.dll
for Windows.
While a UDF is loaded, information about it is available from the
Performance Schema
user_defined_functions
table. See
Section 5.7.2, “Obtaining User-Defined Function Information”.
The statement also registers the UDF in the
mysql.func
system table to cause the server to
load it on subsequent restarts. For this reason,
CREATE FUNCTION
requires the
INSERT
privilege for the
mysql
database.
To remove a UDF, use the DROP
FUNCTION
statement. For example:
CREATE FUNCTION
unloads the UDF and
removes it from the mysql.func
system table.
For this reason, DROP FUNCTION
statement requires the DELETE
privilege for the mysql
database. With the UDF
no longer registered in the table, the server does not load the
UDF automatically for subsequent restarts.
You cannnot use CREATE FUNCTION
to
reinstall a function that has previously been installed. To
reinstall a function, first remove it with
DROP FUNCTION
, then install it
again with CREATE FUNCTION
. You
would need to do this, for example, if you upgrade to a new
version of MySQL that provides an updated implementation of the
function, or you recompile a new version of a function that you
have written. Otherwise, the server continues to use the old
version.
If the server is started with the
--skip-grant-tables
option, it does
not consult the mysql.func
table and does not
load the UDFs listed there.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-udf-loading.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.