MySQL Update in While loop

Question

There is probably a simple solution to this but I can't figure it out: I'm trying to UPDATE in a While loop (from the phpMyAdmin panel):

DELIMITER $$
CREATE PROCEDURE proc_name()
BEGIN
DECLARE c int ;
SET c = 509 ;
WHILE c<637 DO
  UPDATE foobar
    SET `qwerty`= 10000+c-509
    WHERE `product_id` IS c ;
  SET c = c + 1 ;
END WHILE;
END $$
DELIMITER ;

The error:

..near 'c ; SET c = c + 1 ; END WHILE ; END' at line 9.

sgeddes · Accepted Answer · 2013-02-12 19:24:00Z

2

Try changing it to this:

WHERE `product_id` = c ;

answered Feb 12, 2013 at 19:24

sgeddes

62.9k7 gold badges68 silver badges85 bronze badges

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

1 Comment

sgeddes Over a year ago

@Igor -- it passed -- you mean the SP was created successfully? And then you called it? Does your table have a product id of 509?

Collectives™ on Stack Overflow

MySQL Update in While loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related