MySQL modify field value allow NULL

Columns are nullable by default. As long as the column is not declared UNIQUE or NOT NULL . However, things may change during development or to prevent insert error.
Thus, run this comman, example:

ALTER TABLE `table_name` MODIFY `table_field` varchar(255) NULL;

By Keenlio, December 19, 2013

What do you think?

Leave a Reply

Your email address will not be published. Required fields are marked *


× five = 15

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>