Alter SQL table - allow NULL column value Alter SQL table - allow NULL column value sql sql

Alter SQL table - allow NULL column value


ALTER TABLE MyTable MODIFY Col3 varchar(20) NULL;


The following MySQL statement should modify your column to accept NULLs.

ALTER TABLE `MyTable`ALTER COLUMN `Col3` varchar(20) DEFAULT NULL