Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller. It is not permitted to assign the ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/upgrading.html
Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first on some test systems to make sure everything works smoothly, and ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
Similarly, the type of a user variable employed in a statement within a stored procedure is determined the first time the stored procedure is invoked, and retains this type with each subsequent invocation. You can store a value in a user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
To reconfigure the TLS context at runtime, use this procedure: Set each TLS context-related system variable that should be changed to its new value. The members of each pair of system and status variables may have different values temporarily due to ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
Use of database symlinks on Windows is similar to their use on Unix, although the procedure for setting up the link differs. On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
Then, before calling mysql_stmt_execute() to execute the statement, use the following procedure to set up each temporal parameter: In the MYSQL_BIND structure associated with the data value, set the buffer_type member to the type that indicates what ... The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-native-function.html
To add a native MySQL function, use the procedure described here, which requires that you use a source distribution. If you migrate to another version of MySQL (for example, when a new version is released), you must repeat the procedure with the ...