MySql修改表

发布:2011-06-29 14:38   点击315次   评论:0

ALTER TABLE `webtyps`
ADD `tmpPics` tinyint unsigned NOT NULL AFTER `TypResume`,
ADD `tmpPExt` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpPics`,
ADD `tmpList` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpPExt`,
ADD `tmpLink` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpList`,
ADD `tmpShow` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpLink`,
ADD `tmpRem` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpShow`,
ADD `tmpVote` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpRem`,
ADD `tmpNext` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpVote`,
COMMENT=''''
REMOVE PARTITIONING;


ALTER TABLE `admsyst`
ADD `tmpPics` tinyint unsigned NOT NULL AFTER `SysNEng`,
ADD `tmpPExt` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpPics`,
ADD `tmpList` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpPExt`,
ADD `tmpLink` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpList`,
ADD `tmpShow` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpLink`,
ADD `tmpRem` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpShow`,
ADD `tmpVote` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpRem`,
ADD `tmpNext` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpVote`,
COMMENT=''''
REMOVE PARTITIONING;

关于 GitHub 导航 部门 反馈

提示:`/home.php`入口数据仅为演示功能,不构成任何交易凭证,也不承担相关风险和责任!

Copyright © 2011-2018 xxxxx.com All rights reserved.

Run:2.935/42.971(ms); 7(sql)/2.879(MB); comm:news/detail; Upd:2025-01-11 08:14:38