Modifying the null column for a specific row in MySQL?

Question

I'm trying to modify a row, marketing_schedule, in my database to change the column to NULL to NO.

I've tried the command ALTER TABLE permissions MODIFY marketing_schedule tinyint(1) NOT NULL; as given in How to add not null constraint to existing column in MySQL5.1 but I get the error shown in the screenshot above. Any idea on why I'm getting this error and how I can go about fixing my problem?

If it's an INT column, how can you change its value to NO? That's a string, not an integer. — Barmar
– Barmar, Commented Jun 25, 2018 at 16:59

slaakso · Accepted Answer · 2018-06-25 16:19:36Z

2

Update rows which have NULL's in marketing_schedule to have a value and run the ALTER TABLE command again.

answered Jun 25, 2018 at 16:19

slaakso

9,1452 gold badges19 silver badges29 bronze badges

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

Comments

Ashwani Tiwari · Accepted Answer · 2018-06-25 16:24:09Z

1

If your are providing the default not null then you have to provide default value in query

These query run after the update , as answered by @slaakso

ALTER TABLE `table_name` Modify `column_name` TINYINT(4) DEFAULT 1 NOT 
NULL;

OR

 ALTER TABLE `table_name` CHANGE `column_name` `column_name` TINYINT(4) 
 DEFAULT 1 NOT NULL;

Here 1 is default value

answered Jun 25, 2018 at 16:24

Ashwani Tiwari

1,59720 silver badges29 bronze badges

Collectives™ on Stack Overflow

Modifying the null column for a specific row in MySQL?

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