UPDATE ha_app_gift g
SET g.giftType =
CASE g.type
WHEN "热门礼包" THEN
1
WHEN "独家礼包" THEN
2
WHEN "本周上新" THEN
3
WHEN "开服礼包" THEN
4
END
ALTER table `ha_app_gift` DROP COLUMN type;
alter table `ha_app_gift` change giftType type TINYINT(2) COMMENT "ha_app_giftType表中的主键";
SET g.giftType =
CASE g.type
WHEN "热门礼包" THEN
1
WHEN "独家礼包" THEN
2
WHEN "本周上新" THEN
3
WHEN "开服礼包" THEN
4
END
ALTER table `ha_app_gift` DROP COLUMN type;
alter table `ha_app_gift` change giftType type TINYINT(2) COMMENT "ha_app_giftType表中的主键";
alter table `ha_app_gift` MODIFY COLUMN type TINYINT(2) COMMENT "ha_app_giftType表中的主键" AFTER `name`
参考链接:http://www.jb51.net/article/41852.htm(很不错)