How can we change the name of a column of a table?
Answer Posted / chaithra.t
ALTER TABLE tablename RENAME COLUMN old_columnname TO
new_columnname;
above is to change the column name of the table.
In case if u want to change the table name then:
ALTER TABLE tablename RENAME TO new_tablename;
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How to present a past time in hours, minutes and seconds?
How do I backup mysql database on linux?
How to concatenate two character strings?
How to convert dates to character strings?
How to include numeric values in sql statements?
Explain the storage engines in mysql?
Which statement is used to delete a table in MySQL.
What is the difference between unix timestamp and mysql timestamp?
What is the use of mysqli_fetch_assoc?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How do I insert an image into mysql workbench?
What is memory table in mysql?
What are the different data types in mysql?
What are mysql queries?
Where is mysql data stored linux?