gpt4 book ai didi

php - 如何在 Laravel 上调用存储过程?

转载 作者:行者123 更新时间:2023-12-04 12:39:31 30 4
gpt4 key购买 nike

当我像这样在 laravel5 中运行更新存储过程时出现错误..

QueryException in Connection.php line 620:
SQLSTATE[42000]:
Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Sandeep,09999999999,,,sandeep@gmail.com,,,,,,,)' at line 1 (SQL: call sp_clientupdate(108, Sandeep,09999999999,,,sandeep@gmail.com,,,,,,,))



我的代码是....
return DB::select('call sp_clientupdate(108, Sandeep,0999999999,,,sandeep@gmail.com,,,,,,,)');

请任何人给我解决方案.....

最佳答案

你改变。

return DB::select('call sp_clientupdate("108", "Sandeep","0999999999","","","sandeep@gmail.com","","","","","","",)');

尝试它完美地工作......

关于php - 如何在 Laravel 上调用存储过程?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/30498227/

30 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com