[MySQL]CONCAT-문자열합치기 / ALIAS - 별칭

1)CONCAT(문자열A, 문자열B, ...)

2)AS별칭

SELECT 
	email,
    CONCAT(height, 'cm',', ',weight, 'kg') AS '키와 몸무게',
	weight / ((height/100) * (height/100)) AS BMI
FROM copang_main.member;