Mask Mask - 6 months ago 18
MySQL Question

How to change MySQL column definition?

I have a mySQL table called test:

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


I want to change the locationExpect column to:

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


How can it be done quickly?

Answer

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);