WHILE语句中的MySQL语法错误 [英] MySQL syntax error in WHILE statement

问题描述

我正在学习MySQL(v 5.6)，并尝试通过一个简单的WHILE循环.我什至只是直接复制&从手册粘贴(添加SELECT v1;语句)

I'm working through learning MySQL (v 5.6) and trying to get a simple WHILE loop to go through. I even just straight copy & paste from the manual (with added SELECT v1; statement).

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;

  WHILE v1 > 0 DO
    SELECT v1;
    SET v1 = v1 - 1;
  END WHILE;
END;

工作台给我这个错误:

创建过程dowhile()开始声明v1 INT默认 5错误代码:1064.检查 与您的MySQL服务器版本相对应的手册 在第3行0.001秒处在''附近使用的语法

CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5 Error Code: 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 '' at line 3 0.001 sec

非常感谢经验丰富的MySQL程序员提供的任何见解！

Any insight from more experienced MySQL programmers is very appreciated!

推荐答案

该过程看起来还不错，我想您缺少分隔符

The procedure looks ok I guess you are missing the delimiter

delimiter //
CREATE PROCEDURE dowhile()
  BEGIN
   DECLARE v1 INT DEFAULT 5;
    WHILE v1 > 0 DO
     SET v1 = v1 - 1;
   END WHILE;
 END; //
delimiter ;

这篇关于WHILE语句中的MySQL语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！