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

3

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:

edited Mar 24, 2019 at 2:53

answered Mar 24, 2019 at 2:46

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

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

1

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

edited Mar 24, 2019 at 3:14

answered Mar 24, 2019 at 3:08

bimal sharma

1691 silver badge9 bronze badges

Collectives™ on Stack Overflow

mysql, Create Column with a default value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related