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
How do I start mysql from command line?
Write a query to create a database and a table?
How to show table names with 'mysqlshow'?
What is mysql and why it is used?
How do I rename a mysql database?
What is inner join in mysql?
What is mysql root?
What storage engines are used in MySQL?
What is full form of xampp?
How can you find out the version of the installed mysql?
What is unsigned int in mysql?
What is mysql protocol?
How to create a new table in mysql?
How do I find the size of a mysql database?
How do I exit mysql?