MySQL stored procedure requires delimiter

DELIMITER &&
CREATE PROCEDURE Syncadvertiser ()
BEGIN
DECLARE ID bigint;
DECLARE _cur CURSOR for SELECT ID from advertisers;
OPEN _cur;
REPEAT
FETCH _cur into ID;
Sql
UNTIL 1>0 END REPEAT;
CLOSE _cur;
END;
DELIMITER;

DELIMITER && and DELIMITER should be noted ; Two sentences,DELIMITER is the meaning of the separator, because MySQL defaults to ";" As a delimiter, if we do not declare the separator, then the compiler will treat the stored procedure as an SQL statement, the process of compiling the stored procedure will be error-free, so you have to use the DELIMITER keyword in advance to declare the current segment delimiter, so that MySQL will not be ";" As the code in the stored procedure, the code is not executed and the delimiter is restored after it is exhausted.

MySQL stored procedure requires delimiter