¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita0
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 Respuestas
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.