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: 
Try this

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

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

```