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 to include character strings in sql statements?
Can not connect to mysql server 10060?
What is the password of mysql?
Can you rename a database in mysql?
How to return query output in xml format?
all the queries used in sql
what are the different tables present in mysql? : Mysql dba
What is the date format in mysql?
What is datadir?
Which statement is used to delete a table in MySQL.
How does select query work?
Why mongodb is faster than mysql?
How to use regular expression in pattern match conditions?
Can you tell how to find the number of rows in a resultset using php?
Write a query to fetch duplicate records from a table using mysql?