深圳全飞鸿

标题: mysql修改表结构-增加表栏位 [打印本页]

作者: zhgc 时间: 2021-10-29 17:41
标题: mysql修改表结构-增加表栏位
本帖最后由 zhgc 于 2023-5-24 10:05 编辑

alter table `sfc`.`c_keyparts_desc_t`
add column `SN_RULE` varchar(50) NULL after `KP_DESC`,
add column `SN_LENGTH` int DEFAULT '0' NULL after `SN_RULE`,
add column `SN_CHAR` varchar(50) NULL after `SN_LENGTH`,
add column `SN_CAN_DUP` varchar(1) DEFAULT 'N' after `SN_CHAR`,
add column `SN_PREFIX` varchar(25) NULL after `SN_CAN_DUP`,
add column `SN_SUFFIX` varchar(25) NULL after `SN_PREFIX`,
add column `SN_MIN` varchar(50) NULL after `SN_SUFFIX`,
add column `SN_MAX` varchar(50) NULL after `SN_MIN`,
add column `WORK_TIME` datetime NULL after `SN_MAX`

CREATE TABLE `c_keyparts_desc_t` (
  `KEY_PART_NO` varchar(40) NOT NULL,
  `KP_NAME` varchar(20) DEFAULT NULL,
  `KP_DESC` varchar(120) DEFAULT NULL,
  `SN_RULE` varchar(50) DEFAULT NULL,
  `SN_LENGTH` int(11) DEFAULT '0',
  `SN_CHAR` varchar(50) DEFAULT NULL,
  `SN_CAN_DUP` varchar(1) DEFAULT 'N',
  `SN_PREFIX` varchar(25) DEFAULT NULL,
  `SN_SUFFIX` varchar(25) DEFAULT NULL,
  `SN_MIN` varchar(50) DEFAULT NULL,
  `SN_MAX` varchar(50) DEFAULT NULL,
  `WORK_TIME` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

作者: zhgc 时间: 2023-5-14 16:25
alter table `wms`.`r_good_docin_t`
add column `WO` varchar(50) NULL after `WORK_TIME`,
add column `MOVE_TYPE` varchar(20) NULL after `WO`,
add column `DEMO` varchar(200) NULL after `MOVE_TYPE`;

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)