How can we change the name and data type of a column of a
table?
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
What are the different types of triggers in mysql?
Where is mysql password stored?
How do you login to MySql using Unix shell?
Can varchar be primary key?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
Why is mysql used?
What does mysql flush privileges do?
What is difference between group by and order by clause?
How to get a list of columns in an existing table?
How many rows mysql can handle?
What is difference between mongodb and mysql?
What happens if you no create privilege in a database?
What is the use of innodb in mysql?
Write a command with which mysql table can be repaired
If we use sum function in mysql, does it return sum of that row or for that column?