How custom column name generated?

Question

He didn't give SQRT(cost) as SQRT(cost) in query. but column name came as SQRT(cost) .. somebody please explain ? thanks in advance :-)

Answer 1

it's by default what ever function we use mysql assume it as a column name

Answer 2

That's the default name.. Whatever function statement you use will be assigned as name to the column. Of it should be renamed, we can use SQRT(number) AS SquareRoot

Answer 3

unless and until you are not giving any name for column after AS, SQL will take same name as you typed after SELECT statment.