Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок0
How custom column name generated?
He didn't give SQRT(cost) as SQRT(cost) in query. but column name came as SQRT(cost) .. somebody please explain ? thanks in advance :-)
3 ответов
0
it's by default what ever function we use mysql assume it as a column name
0
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
0
unless and until you are not giving any name for column after AS, SQL will take same name as you typed after SELECT statment.