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.

Answer: 
You can do so

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

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

```