Error while changing/altering column name in MySql?

Question

I am trying to change column Customer_email to customerEmail but it gives error

The code which is giving error is

alter table getCustomer
change Customer_email customerEmail varchar;

The code is working fine with "int" type columns.

Answer 1

For the type VARCHAR, you have to give the maximum length of the string, e.g., VARCHAR(50).