How to Rename a Column in MySQL Table
Notes:
How to rename a column in MySQL:
- To rename a column; we take help of alter table command
Basic Syntax:
alter table tablename change current_column_name newname_for_the_column datatype(size);
Ex:
alter table tbl_student change id rollnum int(11);
Interview Questions:
