Description:
"13.1.16 CREATE PROCEDURE and CREATE FUNCTION Syntax" chapter in the "MySQL 5.7 Reference Manual" was describe as following:
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] routine_body
CREATE
[DEFINER = { user | CURRENT_USER }]
FUNCTION sp_name ([func_parameter[,...]])
RETURNS type
[characteristic ...] routine_body
...
routine_body:
Valid SQL routine statement
...
The routine_body consists of a valid SQL routine statement. This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END.
In a word, "CREATE PROCEDURE" syntax and "CREATE FUNCTION" syntax all accord with this rule.
However, "CREATE FUNCTION" syntax can not be combined with INSERT sentence, because of "No RETURN found in FUNCTION", and will throw an error message "ERROR 1320 (42000): No RETURN found in FUNCTION test.f1". Nevertheless, the same INSERT sentence can be used on "CREATE PROCEDURE" syntax with no problem.
How to repeat:
use test;
create table t1(id INT,name varchar(50),sex ENUM('male','female'),birthday DATE);
insert into t1 values(1,'tom','male','1996-01-01');
insert into t1 values(2,'jack','male','1996-06-12');
insert into t1 values(3,'jerry','female','1995-09-12');
create procedure p1() insert into t1 values(4,'mike','male','1998-03-27');
create function f1() returns int insert into t1 values(5,'judy','female','1997-08-01');
Description: "13.1.16 CREATE PROCEDURE and CREATE FUNCTION Syntax" chapter in the "MySQL 5.7 Reference Manual" was describe as following: CREATE [DEFINER = { user | CURRENT_USER }] PROCEDURE sp_name ([proc_parameter[,...]]) [characteristic ...] routine_body CREATE [DEFINER = { user | CURRENT_USER }] FUNCTION sp_name ([func_parameter[,...]]) RETURNS type [characteristic ...] routine_body ... routine_body: Valid SQL routine statement ... The routine_body consists of a valid SQL routine statement. This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END. In a word, "CREATE PROCEDURE" syntax and "CREATE FUNCTION" syntax all accord with this rule. However, "CREATE FUNCTION" syntax can not be combined with INSERT sentence, because of "No RETURN found in FUNCTION", and will throw an error message "ERROR 1320 (42000): No RETURN found in FUNCTION test.f1". Nevertheless, the same INSERT sentence can be used on "CREATE PROCEDURE" syntax with no problem. How to repeat: use test; create table t1(id INT,name varchar(50),sex ENUM('male','female'),birthday DATE); insert into t1 values(1,'tom','male','1996-01-01'); insert into t1 values(2,'jack','male','1996-06-12'); insert into t1 values(3,'jerry','female','1995-09-12'); create procedure p1() insert into t1 values(4,'mike','male','1998-03-27'); create function f1() returns int insert into t1 values(5,'judy','female','1997-08-01');