How can we change the name of a column of a table?
Answer Posted / owais masood
RENAME cannot be used to change the column name, however, it
is used to change the table or database name. However the
CHANGE is used to to rename a column with the su=yntax given
above by vipul (Answer 2)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is faster mongodb or mysql?
What is delimiter in mysql?
How do you stop an access query?
What is the function of myisamchk?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Is mysql and sql are same?
How many sql ddl commands are supported by 'mysql'?
How do I edit a table in mysql?
Is mysql a relational database?
How to convert character strings to numeric values?
Where is the mysql data directory?
What is the difference between is null & is not null?
How to get a list of all tables in a database?
What is mysql_query?