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
Are stored procedures precompiled?
Write a query to count the number of rows of a table in mysql.
How to include character strings in sql statements?
What are the advantages/disadvantages of mysql and php?
What is the usage of "i-am-a-dummy" flag in mysql?
What is use command in mysql?
What is mysql procedure?
Write a program using the select statement, while loop.
How much does mysql cost?
How to display nth highest salary from a table in a mysql query?
What is datatype in mysql?
What is 1nf 2nf 3nf?
How do I run mysql on a mac?
How to calculate expressions with sql statements?
Define REGEXP?