How can we change the name and data type of a column of a
table?
- 9 Answers
- 23823 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / m. ravindar
To Change Name of Column:
Sy: Alter Table <Table Name> Change <Old ColumnName> <New
ColumnName>;
Ex: Alter Table Test Change EmpId EID varchar(5);
| Is This Answer Correct ? | 17 Yes | 19 No |
Post New Answer View All Answers
Is there a free mysql?
Write a query to stop mysql in unix
What are the security alerts while using mysql?
What is unsigned int in mysql?
How to see table's field formats or description of table .
What is mysql and mysqli?
Is mysql easy to learn?
Where is the myisam table stored?
What are the differences between a primary key and foreign key?
What is mysql and how it works?
Is mysql case-sensitive?
What is not null in mysql?
How do I download mysql on my laptop?
Why should I learn mysql?
How set mysql root password?
