Shulou(Shulou.com)05/31 Report--

This article is about how phpmyadmin creates functions in a database. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

Create a function in a database on phpmyadmin

Change that PHP project added a function, local MYSQL added a function, now to go to the server, and then MYSQL on the server can only be operated through the PHPMYADMIN web page, SQL on the web page enter the statement to create the function

This function has none of DETERMINATION

Check this reason: www.php.cn/mysql-tutorials-477456.html

Set global log_bin_trust_function_creators=1;

Another my local MYSQL is connected with SQLYOG, the exported function creation statement has comments such as/*, which need to be removed when placed on PHPMYADMIN, otherwise it may not be executed, and that

DEFINER=`root`@`%` Also remove...

Here is my function creation statement:

USE `sql88_aosijue_c`;DELIMITER $$CREATE FUNCTION `calc_xjs`(user_id int) RETURNS int(11)BEGIN return (SELECT COUNT(1) FROM tp_users WHERE pid=user_id);END $$DELIMITER ;

Note that if PHPMYADMIN is executed on the server, the database name after USE should also be consistent with that on the server.

Thank you for reading! About "phpmyadmin how to create functions in a database" This article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.