sql-formatter
sql-formatter copied to clipboard
mysql: create procedure LOOP bug
label:
LOOP
FETCH cur_1 INTO
event_id,only_code,garage,space;
IF done THEN
LEAVE label;
END IF;
set @SqlStmtA1 = concat('delete from ', eventtablename, ' where id=', event_id);
prepare stmtA1 FROM @SqlStmtA1;
EXECUTE stmtA1;
COMMIT;
END LOOP;
CLOSE cur_1;