首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >MySQL存储过程;多状态过程,抛出错误

问MySQL存储过程;多状态过程,抛出错误
EN

Stack Overflow用户
提问于 2016-04-23 05:43:04
回答 1查看 22关注 0票数 0
代码语言:javascript
复制
UPDATE Decks 
JOIN Amount ON amount.DeckName = decks.DeckName 
SET decks.DeckTotal = Decks.DeckTotal - Decks.DeckTotal
WHERE Amount.AmountName = @aName;

UPDATE Types t1
JOIN Cards ON cards.TypeName = t1.TypeName 
JOIN Amount ON amount.CardName = Cards.CardName
SET t1.TypeTotal = t1.TypeTotal - Amount.Amount
WHERE Amount.CardName = @aName;

DELETE * 
FROM Amount 
WHERE CardName = @aName;

当我尝试使用phpMyAdmin将其放入存储过程时,上面的内容会抛出一个错误。它说,第二条语句一开始,我的语法就出错了。

附件是一个错误者的屏幕截图。

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2016-04-23 06:01:03

从删除的*中删除query..Then --它将正常工作

代码语言:javascript
复制
CREATE  PROCEDURE `sp_test`()
Begin
      UPDATE Decks 
      JOIN Amount ON amount.DeckName = decks.DeckName 
      SET decks.DeckTotal = Decks.DeckTotal - Decks.DeckTotal
      WHERE Amount.AmountName =1;

      UPDATE Types t1
      JOIN Cards ON cards.TypeName = t1.TypeName 
      JOIN Amount ON amount.CardName = Cards.CardName
      SET t1.TypeTotal = t1.TypeTotal - Amount.Amount
      WHERE Amount.CardName = @aName;

      DELETE 
      FROM Amount 
      WHERE CardName = @aName;
 end
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/36807124

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档