你如何调试 MySQL 存储过程? [英] How do you debug MySQL stored procedures?

问题描述

我当前调试存储过程的过程非常简单.我创建了一个名为调试"的表，在其中插入存储过程运行时的变量值.这允许我在脚本中的给定点查看任何变量的值，但是有没有更好的方法来调试 MySQL 存储过程?

My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable values from the stored procedure as it runs. This allows me to see the value of any variable at a given point in the script, but is there a better way to debug MySQL stored procedures?

推荐答案

我做了一些与你非常相似的事情.

I do something very similar to you.

我通常会包含一个默认为 false 的 DEBUG 参数，我可以在运行时设置为 true.然后将调试语句包装到If DEBUG"块中.

I'll usually include a DEBUG param that defaults to false and I can set to true at run time. Then wrap the debug statements into an "If DEBUG" block.

我还对我的许多工作使用了日志记录表，以便我可以查看流程和时间安排.我的调试代码也在那里得到输出.我包括调用参数名称、简要说明、受影响的行数(如果适用)、注释字段和时间戳.

I also use a logging table with many of my jobs so that I can review processes and timing. My Debug code gets output there as well. I include the calling param name, a brief description, row counts affected (if appropriate), a comments field and a time stamp.

好的调试工具是所有 SQL 平台的可悲失败之一.

Good debugging tools is one of the sad failings of all SQL platforms.

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