I have a large MyISAM table, and I would like to change the default value for one of the columns. Using mysql 5.1.31, I issue the following command:
ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64;
Although this should cause only a simple modification to the .frm file, mysql insists on copying the entire table:
±—±-----±----------±---------------±--------±-----±------------------±-----------------------------------------------------------------------------+| Id | User | Host | db | Command | Time | State | Info |±—±-----±----------±---------------±--------±-----±------------------±-----------------------------------------------------------------------------+| 90 | root | localhost | mog_production | Query | 48 | copy to tmp table | ALTER TABLE medianet_media_files ALTER COLUMN feed_created_id SET DEFAULT 64 | | 91 | root | localhost | mog_production | Query | 0 | NULL | show full processlist | ±—±-----±----------±---------------±--------±-----±------------------±-----------------------------------------------------------------------------+2 rows in set (0.00 sec)
Any ideas?