MYSQL MODIFY column to NULL

Some newer version of phpmyadmin by default when create field name not allow NULL.
after added the field, we can use MODIFY command to change it default null.

Mysql MODIFY command example:

ALTER TABLE `table_name` MODIFY `column_field` varchar(255) null;

By Keenlio, March 17, 2014

What do you think?

Leave a Reply

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


four − 2 =

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>