MySQL Stored Procedure error

Question

I have a simple stored procedure which inserts records into four character fields in table. Below is the procedure

CREATE PROCEDURE dowhile()

BEGIN

DECLARE I INT DEFAULT 5

v1loop: WHILE I < 10000 DO

   INSERT INTO TestTable1(A,B,C,D)

   SELECT CONCAT(I,'A'), CONCAT(I,'B'), CONCAT(I,'C'), CONCAT(I,'D')

   SET I = I + 1

END WHILE v1loop

END;

Checked online - there are no free MSSQL to MYSQL SQL Conversion Tools

Error is - SQL Syntax Error in Insert - SELECT Statement

I have checked the syntax this seem to be correct.

Any pointers for this would be helpful.

onteria_ · Accepted Answer · 2011-05-24 14:10:57Z

2

Not to bad actually, you just need to add some semi-colons and change MySQL's default delimiter. This needs to be done since we're using SQL inside SQL.

DELIMITER $$

CREATE PROCEDURE dowhile()

BEGIN

DECLARE I INT DEFAULT 5;

v1loop: WHILE I < 10000 DO

   INSERT INTO TestTable1(A,B,C,D)

   SELECT CONCAT(I,'A'), CONCAT(I,'B'), CONCAT(I,'C'), CONCAT(I,'D');

   SET I = I + 1;

END WHILE v1loop;

END$$

DELIMITER ;

Just tested this on my MySQL server.

answered May 24, 2011 at 14:10

onteria_

70.9k7 gold badges73 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

MySQL Stored Procedure error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related