Answers for "how to change the column name in select query"

how to change the column name in sql

ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;

Posted by: Guest on March-17-2021

change column name sql

ALTER TABLE `db_name`.`table_name` 
	CHANGE `current_column_name` `new_column_name` datatype(size) NOT NULL COMMENT '';

Posted by: Guest on December-06-2020

Code answers related to "how to change the column name in select query"