DROP PROCEDURE IF EXISTS w_array;

 DELIMITER /w/

 CREATE PROCEDURE w_array (w_arr  VARCHAR(36))

 BEGIN

 WHILE (LOCATE(',', w_arr) > 0)

 DO

         SET @w = LOCATE(',', w_arr);

     SET @wtab = SUBSTRING_INDEX(w_arr,',',1);

     SET @wtab = CONCAT('grab_reviews_',@wtab);

         SET @wtmp =  CONCAT('UPDATE  ',@wtab,' SET asin=exact_asin ');

         PREPARE  stmt FROM @wtmp ;

         EXECUTE  stmt  ;

         DROP PREPARE stmt;

         SET w_arr=SUBSTRING(w_arr,@w+1);

 END WHILE;

     SET @wtab = CONCAT('grab_reviews_',w_arr);

         SET @wtmp =  CONCAT('UPDATE  ',@wtab,' SET asin=exact_asin ');

         PREPARE  stmt FROM @wtmp ;

         EXECUTE  stmt  ;

         DROP PREPARE stmt;

 END/w/

 DELIMITER;

 CALL w_array('us,jp,uk,de,fr,ca,es,it,mx,in');

 <?php

 $warr = array('us', 'jp', 'uk', 'de', 'fr', 'ca', 'es', 'it', 'mx', 'in');

 $sql = 'UPDATE grab_reviews_';

 $w = '';

 foreach ($warr AS $one) {

     $w .= 'UPDATE grab_reviews_' . $one . ' SET asin=exact_asin ; ';

 }

 echo $w;

 DROP PROCEDURE IF EXISTS w_array;

 DELIMITER /w/

 CREATE PROCEDURE w_array ()

 BEGIN

 SET @w_arr = 'us,jp,uk,de,fr,ca,es,it,mx,in';

 WHILE (LOCATE(',', @w_arr) > 0)

 DO

         SET @w = LOCATE(',', @w_arr);

     SET @wtab = SUBSTRING_INDEX(@w_arr,',',1);

     SET @wtab = CONCAT('grab_reviews_',@wtab);

         SET @wtmp =  CONCAT('UPDATE  ',@wtab,' SET asin=exact_asin ');

         PREPARE  stmt FROM @wtmp ;

         EXECUTE  stmt  ;

         DROP PREPARE stmt;

         SET @w_arr=SUBSTRING(@w_arr,@w+1);

 END WHILE;

     SET @wtab = CONCAT('grab_reviews_',@w_arr);

         SET @wtmp =  CONCAT('UPDATE  ',@wtab,' SET asin=exact_asin ');

         PREPARE  stmt FROM @wtmp ;

         EXECUTE  stmt  ;

         DROP PREPARE stmt;

 END/w/

 DELIMITER;

 CALL w_array;