Alex Rivera | Logout

Removing NOT NULL restriction from column in MySQL

Asked 2011-04-18T18:55:04.420
18

How can I alter a column whose restricted to NOT NULL to accept NULL values?

Edit
Report

1 Answer

27

just modify it and put in the old type and leave off the not null

alter table table_name modify column foo int;
answered 2011-04-18T18:58:11.267

Your Answer