mysql 更改列的默认值,如何在MySql中更改列默认值

I am using MySql5.5.

I have a table media__gallery and I want change the default value of the column default_format from 'NO' to 'YES', but when I write the query and run through command line nothing is updated.

My Query :

ALTER TABLE `media__gallery` CHANGE `default_format` `default_format` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_bin NULL DEFAULT 'YES';

MySql Table :

mysql> desc media__gallery;

+----------------+--------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+----------------+--------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(255) | NO | | NULL | |

| context | varchar(64) | NO | | NULL | |

| default_format | varchar(255) | NO | | NULL | |

| enabled | tinyint(1) | NO | | NULL | |

| updated_at | datetime | NO | | NULL | |

| created_at | datetime | NO | | NULL | |

| category_id | int(11) | YES | UNI | NULL | |

+----------------+--------------+------+-----+---------+----------------+

What am I missing here?

解决方案

ALTER TABLE media_gallery

ALTER COLUMN default_format SET DEFAULT 'YES'

This should do the trick.