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
What is bigint in mysql?
How to increment dates by 1 in mysql?
how can you test for null values in a database? : Mysql dba
How do I select a database in mysql workbench?
What is root password?
What is RMS Migrations
What are the differences between char and nchar?
What data type is money?
What causes mysql too many connections?
Is mysql case-sensitive?
What is the usage of "i-am-a-dummy" flag in mysql?
What are the differences between innodb and myisam engines?
What does blob mean in mysql?
How do I start and stop mysql server?
change column name and make a unique column so we get no dupes.