mysql 在存储过程中输出日志信息

CREATE DEFINER=root@127.0.0.1 PROCEDURE pro_test1()
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
declare myvar INT default 0;
SET myvar = 5;
SELECT concat('myvar is ', myvar); /用concat连接变量输出/
SELECT ‘Comment’; /直接用select 打印输出/

/创建一个有一列文本列的表，然后往里面塞信息/
insert into protmptable select concat('myvar is ', myvar);
END