A

Admin • 802.91K Points
Coach

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;
  • Correct Answer - Option(C)
  • Views: 6
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
`ALTER TABLE ... CHANGE old_name new_name datatype;` is used to rename a column.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.