Change or rename column name in SQL | Mysql tutorial

How to change or rename column name in SQL in mysql workbench is shown

[olehharhat]

Thanks man, i have been searching for right syntax for like 1 hour.

[PramodYadav-ilgk]

SELECT * FROM Persons;

ALTER TABLE Persons
CHANGE PersonID Sno varchar(50);

Msg 102, Level 15, State 1, Line 23
Incorrect syntax near 'CHANGE'.

sir i am facing this issue
i am using mysql 2019

[akashrawat]

if my old column has space how can I replace with underscore?

[vinfinity]

It doesn't work for me I use pg4admin 14th version. And it shows that there's a syntax error at or near "change".

[Tanya-ddcm]

incorrect syntax near change what to do?

[abhishekranjan]

you haven't changed the column name. you have changed the only data type.