How can we change the name of a column of a table?

Answer Posted / shweth

we can use ALIAS function for this
select tree AS plant
from table;
or simply we can skip writing AS but shoudnt write a comma
between the old and new column names.

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database clustering in mysql?

483


Can varchar be primary key?

508


Can python connect to mysql?

486


How do I find the size of a mysql database?

486


What is the use of count function in mysql?

562






Why does mysql have so many connections?

491


How to use count function in mysql?

481


Can mysql function return a table?

603


How to shutdown mysql server?

582


What is the latest mysql?

480


What does innodb stand for?

531


What is sql in mysql?

569


why not null is not allowed at table level

2293


Explain % and _ inside like statement?

590


What is procedural api?

501