MySQL存储过程初学者指南? [英] Beginners' guide to stored procedures with MySQL?

问题描述

我已经用Google搜索，但想出的任何办法都无法解决.

I've Googled but come up with nothing that I can get my head around.

使用存储过程获得的性能提升是否显着?

Are the performance gains from using stored procedures significant?

我还是要与存储的proc一起使用准备好的语句吗?或者通常是一回事吗?

Would I still want to use prepared statements in conjunction with stored procs or is it generally a one or the other thing?

我可以通过PHPMyAdmin创建存储的proc并从那里进行管理吗?

Can I create stored procs through PHPMyAdmin and manage them from there as well?

对于像这样的简单存储过程，存储过程将是什么样的?

What would a stored procedure look like for something simple like this-

SELECT * FROM table a 
INNER JOIN otherTable b 
ON a.join_id=b.join_id 
WHERE someVar = :boundParam

PHP将如何工作(PDO)来调用它并绑定其参数?

and how would the PHP work (PDO) to call it and bind its parameter?

推荐答案

请仔细考虑一下MySQL中的存储过程:

Consider this a gentle introduction to stored procedures in MySQL: http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

您确定可以在phpMyAdmin中创建/管理存储过程.

You sure can create/manage stored procedures in phpMyAdmin.

这篇关于MySQL存储过程初学者指南?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！