Q. How do you rename a column in MySQL?

  • (A) RENAME COLUMN old TO new;
  • (B) ALTER TABLE t RENAME old TO new;
  • (C) ALTER TABLE t CHANGE old new datatype;
  • (D) SET COLUMN old AS new;
πŸ’¬ Discuss
βœ… Correct Answer: (C) ALTER TABLE t CHANGE old new datatype;
Explanation: `ALTER TABLE ... CHANGE old_name new_name datatype;` is used to rename a column.
Explanation by: Mr. Dubey
`ALTER TABLE ... CHANGE old_name new_name datatype;` is used to rename a column.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
99
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
95%
Success Rate