存储过程,连接符,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       |
+----------+
*/