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
can you elaborate on blob and text in mysql? : Mysql dba
How to use in conditions?
Why do we need mysql?
Why is mysql popular?
What is procedures in mysql?
Why do we use preparedstatement?
What is the date format in mysql?
How to get the number of rows selected or affected by a sql statement?
what is the difference between between and in operators in mysql?
What is max connection in mysql?
What are queries used for?
What is mysqlcheck do?
Do while loop in mysql procedure?
What are the mysql database files stored in system ?
Why we use mysql workbench?