阿神2017-04-17 16:43:40
The semicolon is the terminator of the mysql command, and DELIMITER is used to change the input terminator.
ringa_lee2017-04-17 16:43:40
The semicolon after the INSERT and RETURN statements is to separate multiple statements in the function/stored procedure. Otherwise, how do you divide the multiple statements in the stored procedure?