select distinct field,concat(field,field) from table;
将两列合并为一列
select distinct field,concat(field,'|',field) from table;
加个分割符
SELECT group_concat( `field` SEPARATOR ',' ) AS allrow FROM table group by field;将字段的值相同的行合并
另一篇合并行的文章: http://hi.baidu.com/276598908/blog/item/c4dbfd2728b3f709908f9d52.html
自定义变量:
set @varname='';
select 自定义变量; 输出变量的值