How Can We Change The Name Of A Column Of A Table?

1.	How Can We Change The Name Of A Column Of A Table?
Answer» MySQL QUERY to rename table: RENAME TABLE tbl_name TO new_tbl_name or, ALTER TABLE tableName CHANGE OldName newName. MySQL query to rename table: RENAME TABLE tbl_name TO new_tbl_name or, ALTER TABLE tableName CHANGE OldName newName.

Answer»

MySQL QUERY to rename table: RENAME TABLE tbl_name TO new_tbl_name
or,
ALTER TABLE tableName CHANGE OldName newName.

MySQL query to rename table: RENAME TABLE tbl_name TO new_tbl_name
or,
ALTER TABLE tableName CHANGE OldName newName.

Discussion