How can we change the name of a column of a table?
Answer Posted / chandrakant agrawal
ALTER TABLE <owner_name.tab_name> RENAME COLUMN <old_name>
TO <new_name>;
We can also modify the datatype,size of the column using
command alter table
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is mysql_query?
Can mysql handle billions of records?
How many sql dml commands are supported by 'mysql'?
How do you backup a database in mysql?
Can we write procedure in mysql?
What is the maximum size of table in mysql?
How to get a version of mysql?
What is a heap table?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
How can I see all mysql databases?
Is mysql query case sensitive?
What is trigger in mysql with example?
Does facebook still use mysql?
What is csv?
How do I create a new database in mysql?