将分隔符设置为除 ; ，例如： $$ . 这将允许解析器处理整个 create 作为一个整体的声明。
最后，将分隔符重新定义回
; user 是mysql中的关键字。最好将表重命名为其他名称，或者在表周围使用反勾号。
有一个拼写错误；应该是的 HANDLER 不是 HANDLE 尝试：

DELIMITER $$
DROP PROCEDURE IF EXISTS insert_user $$

CREATE PROCEDURE insert_user(in uname varchar(20),
                             in gender varchar(20),
                             in email varchar(20),
                             in phone varchar(20),
                             in pword varchar(20),
                             in city varchar(20)) 
BEGIN
DECLARE finished INT DEFAULT 0;
Declare cnt INT DEFAULT 0;
declare id INT;
DECLARE c_cur CURSOR FOR select user_id from `user`;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;
    open c_cur;
        ins_user: loop
        fetch c_cur into id;

                IF finished = 1 THEN 
                LEAVE ins_user;
                end if; 

                SET cnt:=id; -- set was missing here
                end loop ins_user;
        SET cnt:=cnt+1; -- set was missing here

        insert into `user`
        values(cnt,uname,email,phone,city,pword,gender);
END $$

DELIMITER ;