select CONCAT(field1, '@', field2) as aa from table_name 转载于:https://www.cnblogs.com/davidgu/archive/2013/02/28/2936865.html