Change tinyint default value into 1 mysql

Question

I have a status column in my database table. Type : tinyint(4) and the Default value is 0. I want to change the default value to 1. How to do that? May be this is a very simple question, but I don't know.

M Khalid Junaid · Accepted Answer · 2014-04-04 09:36:02Z

29

You can do so

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

answered Apr 4, 2014 at 9:36

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

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

2 Comments

Strawberry Over a year ago

I've explained above.

Robert Over a year ago

Looks like in phpMyAdmin there is not this possiblity

e-fisher · Accepted Answer · 2014-04-04 09:39:40Z

8

ALTER TABLE MyTable MODIFY COLUMN col TINYINT NOT NULL DEFAULT 1;

answered Apr 4, 2014 at 9:39

e-fisher

6691 gold badge6 silver badges8 bronze badges

Comments

Sadikhasan · Accepted Answer · 2023-03-10 08:01:31Z

3

Try this

ALTER TABLE `Type` CHANGE `status` `status` tinyint(4) NOT NULL DEFAULT 1

edited Mar 10, 2023 at 8:01

answered Apr 4, 2014 at 9:36

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

1 Comment

strix25 Over a year ago

why is '1' in quotes ?

MrCarrot · Accepted Answer · 2014-04-04 09:37:39Z

1

ALTER TABLE `your_table` CHANGE `your_column` `your_column` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '1'

answered Apr 4, 2014 at 9:37

MrCarrot

2,8182 gold badges28 silver badges34 bronze badges

1 Comment

strix25 Over a year ago

why '1' in quotes?

Giacomo1968 · Accepted Answer · 2018-06-27 17:02:47Z

1

If you want add any column in your table you can do this:

ALTER TABLE table_name CHANGE Column_name  tinyint(1) DEFAULT 1 NOT NULL;

edited Jun 27, 2018 at 17:02

Giacomo1968

25.3k11 gold badges78 silver badges106 bronze badges

answered May 16, 2018 at 11:29

Pankaj sharma

392 bronze badges

Collectives™ on Stack Overflow

Change tinyint default value into 1 mysql

5 Answers 5

2 Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related