Syntax error in mysql Loop. MariaDB

Question

I am getting a syntax error at simple_loop: Loop statement saying

Unexpected character near ':'

in the line simple_loop: LOOP

Please help

DELIMITER $$  

CREATE PROCEDURE getTable(fullstr VARCHAR(555))

   BEGIN
      DECLARE a INT Default 0 
      DECLARE str VARCHAR(255)
      simple_loop: LOOP
         SET a=a+1
         SET str=SPLIT_STR(fullstr,",",a)
         IF str='' THEN
            LEAVE simple_loop
         END IF
         #Do Inserts into temp table here with str going into the row
         insert into my_temp_table values (str)
   END LOOP simple_loop
END $$

It might help to reference the function: blog.fedecarg.com/2009/02/22/mysql-split-string-function — Rick James
– Rick James, Commented May 17, 2017 at 3:55

Piyush Gupta · Accepted Answer · 2016-04-16 07:47:27Z

1

It is a very annoying MySQL syntax related issue: There is a TAB somewhere in you procedure leading to this parse issue.

Note: Separate ;

DELIMITER $$  

    CREATE PROCEDURE getTable(fullstr VARCHAR(555))

       BEGIN
          DECLARE a INT Default 0 ;
          DECLARE str VARCHAR(255);
          simple_loop: LOOP
             SET a=a+1;
             SET str=SPLIT_STR(fullstr,",",a);
             IF str='' THEN
                LEAVE simple_loop;
             END IF;
             #Do Inserts into temp table here with str going into the row
             insert into my_temp_table values (str);
       END LOOP simple_loop;
    END $$

answered Apr 16, 2016 at 7:47

Piyush Gupta

2,1813 gold badges16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kanishka Over a year ago

if I use ; , I see errors everywhere. So, had to remove it.

Rick James Over a year ago

Note that ; is not needed everywhere. But it was missing several places.

Collectives™ on Stack Overflow

Syntax error in mysql Loop. MariaDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related