Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 10838 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
Write a command with which mysql table can be repaired
Is pdo more secure than mysqli?
How to rename an existing column in a table?
What is the full form of mysql?
Is mysql owned by oracle?
What is clob in mysql
What is a storage engine? What are the differences between innodb and myisam engines?
What is 1nf 2nf 3nf?
How do you restart mysql?
What are the differences between mysql vs sql server?
What is view? How can you create and drop view in mysql?
How to load data files into tables with 'mysqlimport'?
How do I drop a database in mysql?
What is max connections in mysql?
What is row locking in mysql?
