![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
请问PHP的MYSQL函数是否支持一次性执行以“;”分割的多个SQL语句?在DOS下我已经证实可以正确执行;
SELECT @FCount := CO_Count FROM CoOrder WHERE CO_SubUserID = 2 AND CO_Date = Now() AND CO_CoShopID = 0 AND CO_CoMenuNo = 292; UPDATE Schedule SET CS_Now = CS_Now - @FCount WHERE CS_FoodID = 292 AND CS_Date = Now();
但我试图通过PHP提供的MYSQL执行以上语句时。出现如下错误:
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 '; UPDATE Schedule
但如果将以上的语句放在phpMyAdmin中却能够正确被执行。
请问有哪位知道为什么?
提问者:yoryoue 08-15 17:05
答复

