πŸ“Š MySQL
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

πŸ‘οΈ
72
Total Visits
πŸ“½οΈ
9 mo ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
98%
Success Rate