Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 11129 Views
- I also Faced
- E-Mail Answers
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?
