ALTER TABLE db.table_name CHANGE COLUMN old_column_name new_column_name ENUM(’first’,’second’,'third’) NOT NULL DEFAULT ‘first’;

This entry was posted on Wednesday, September 30th, 2009 at 11:54 am and is filed under mysql, web design. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.