alter table change column to nullable mysql without erasing data code example Example: mysql alter table column nullable ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);