Question

How to rename a column in an existing MySQL table?

Answer 1

ALTER TABLE "table_name" Change "column 1" "column 2" ["Data Type"];

ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

ALTER TABLE Customer CHANGE Address Addr char(50);

ALTER TABLE Customer RENAME COLUMN Address TO Addr;