adspace


How to rename an existing column in a table?

Answer Posted / Puneet Tikkha

To rename an existing column in a MySQL table, you can use the ALTER TABLE statement. Here's an example:n`nALTER TABLE YourTable RENAME COLUMN old_column_name TO new_column_name;n`

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247


What is current version of mysql?

1084


What is the current mysql version?

1105