如何在phpMyAdmin中编写存储过程? [英] How to write a stored procedure in phpMyAdmin?

问题描述

我无法找到在phpMyAdmin中写存储过程的位置以及如何使用MVC架构调用存储过程.

I am not able to find where to write the stored procedure in phpMyAdmin and how to call it using MVC architecture.

推荐答案

在phpMyAdmin中，您可以在SQL窗口中创建存储过程.

In phpMyAdmin you can create the stored procedure in the SQL window.

您可能必须将派尺设置为"$$"之类的值，而不是默认的;".您可以从"SQL"窗口的底部进行更改.

You may have to set the delimieter to something like "$$" instead of the default ";". You can change this from the bottom of the SQL window.

也可以参考以下内容: http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

Also you can refer this: http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

这篇关于如何在phpMyAdmin中编写存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！