Debugging record of MySQL storage function error [Err] 1064

Debugging record of MySQL storage function error [Err] 1064

1. An error is reported when a user creates a storage function.

Create definer = 'root' @ 'localhost' FUNCTION 'stuff '(

2. Check whether the function is Enabled:

Check whether log_bin_trust_function_creators is enabled.

Iii. Analysis

For mysql storage functions, special DELIMITER should be used for distinguishing, and select... into... has been assigned a value. set is redundant, so the modification is as follows:

4. Execute the following operations. All operations are OK.

Mysql> use test;

PS: mysql storage functions or stored procedures have tools that can be directly debugged. Therefore, you need to analyze them carefully and try to use as few stored procedures or stored functions as possible in applications.