MySQL Stored Procedure
DELIMITER $$ CREATE PROCEDURE mysql_update_field() BEGIN DECLARE x INT; DECLARE number INT; DECLARE contador INT; SET x = 1; SET number=1; select count(*) into contador from mdl_user; REPEAT IF exists(select * from mdl_user where id=number) THEN UPDATE mdl_user SET idnumber=username; END IF; SET x = x + 1; SET number =number+1; SET contador=contador+1; UNTIL x […]
MySQL Stored Procedure Leer más »