MySQL concat, group_concat

1. select concat(A컬럼, B컬럼) from test;

2. select group_concat(A컬럼) from test; 
    group_concat(A컬럼 separator ',')