Revisions to mysql, Create Column with a default value

Post Undeleted by D-Shih

occurred Mar 24, 2019 at 2:53

added 128 characters in body

edited Mar 24, 2019 at 2:53

You can try to use UPDATE let typeALTER column set thea default value.

then ALTER column be not null.

UPDATE T SET type = '' WHERE type IS NULL; ALTER TABLE `T` MODIFY `type` varchar(50) NOTDEFAULT NULL;'default';

then insert by DEFAULT keyword:

INSERT INTO T (type) VALUES (DEFAULT);

You can try to use UPDATE let type column set the default value.

then ALTER column be not null.

UPDATE T SET type = '' WHERE type IS NULL; ALTER TABLE `T` MODIFY `type` varchar(50) NOT NULL;

You can try to ALTER column set a default value.

ALTER TABLE `T` MODIFY `type` varchar(50) DEFAULT 'default';

then insert by DEFAULT keyword:

INSERT INTO T (type) VALUES (DEFAULT);

Post Deleted by D-Shih

occurred Mar 24, 2019 at 2:48

answered Mar 24, 2019 at 2:46

You can try to use UPDATE let type column set the default value.

then ALTER column be not null.

UPDATE T SET type = '' WHERE type IS NULL; ALTER TABLE `T` MODIFY `type` varchar(50) NOT NULL;

Return to Answer