你需要解决问题如果你直接运行脚本而不是程序运行脚本会发生什么？

- 你以编程方式创建了什么值 - 它们是正确的类型吗？

- 你是否正确引用你的变量？

参见：http：//www.w3resource.com/mysql/mysql-procedure.php



在上面的参考文献中，他们指出你如何引用一个值取决于它是否是程序的本地。这vs @this

You need to break your problem down into independent parts.
- what happens if you run the script directly instead of in your program?
- what values are you creating, programmatically - are they the right types?
- are you properly referencing your variables?
See: http://www.w3resource.com/mysql/mysql-procedure.php

In the above reference, they point out that how you reference a value depends upon whether it's local to the procedure or not. this vs @this