变更itemid字段类型bigint为int

xuezuo

[ol]

ALTER TABLE `destoon_404`

        AUTO_INCREMENT=1,

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_21_2`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL DEFAULT 0 FIRST;

ALTER TABLE `destoon_article_21`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_ad`

        MODIFY COLUMN `aid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_alert`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_announce`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_address`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_sell_search_5`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_sell_data_5`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL DEFAULT 0 FIRST;

ALTER TABLE `destoon_sell_5`

        MODIFY COLUMN `itemid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `destoon_company_data`

        MODIFY COLUMN `userid` int(11) UNSIGNED NOT NULL DEFAULT 0 FIRST;

ALTER TABLE `destoon_company`

        MODIFY COLUMN `userid` int(11) UNSIGNED NOT NULL DEFAULT 0 FIRST;[/ol]复制代码

xuezuo

操作前请备份数据库，字段类型最好不要变更。

龙在天涯

楼主是牛人

zhao90

不错不错 支持分享

fengshanghang

感谢分享