mysql, Create Column with a default value

Question

I've a table item that has some columns that are nullable. To one of them type, I'd like to automatically insert a default value (instead of a NULL) whenever a new record in inserted in the table and do not specify a value for that column.

Can it be done without affecting the existing data? The type column is a varchar.

I can update the current nulls.

D-Shih · Accepted Answer · 2019-03-24 02:53:01Z

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);

Results:

bimal sharma · Accepted Answer · 2019-03-24 03:14:15Z

This query will work for you.

For update table.

ALTER TABLE `column_name` CHANGE `tab` `my_id` INT(11) NOT NULL DEFAULT '0';

For insert table

CREATE TABLE `db_name`.`Tbale_name` ( `demo` INT NOT NULL DEFAULT '0');

Collectives™ on Stack Overflow

mysql, Create Column with a default value

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related