renaming a column in mysql code example
Example 1: cmd to rename a collumn name in sql
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
Example 2: how to change column name in mysql
alter table product change price price_kg float;
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
alter table product change price price_kg float;