存储过程,连接符,sql_mode

set sql_mode='ansi';

drop procedure if exists p3;

delimiter //

create procedure p3()
select'a'||'b'//  

delimiter ;

set sql_mode='';

call p3();

/*
+----------+
| 'a'||'b' |
+----------+
| ab       |
+----------+
*/