How to change MySQL column definition?

Question

create table test(
    locationExpect varchar(120) NOT NULL;
);

I want to change it to :

create table test(
    locationExpect varchar(120);
);

Answer 1

This should do it:

ALTER TABLE test MODIFY locationExpert VARCHAR(120)

Answer 2

Do you mean altering the table after it has been created? If so you need to use alter table, in particular:

ALTER TABLE tablename MODIFY COLUMN new-column-definition

e.g.

alter table test modify column locationExpect varchar(120);

Answer 3

This should do it

ALTER TABLE TEST

ALTER COLUMN [locationExpect] varchar(120) NULL

GO

edit: Ah my solution is for SQL Server, didn't see MySQL