- ALTER TABLE `AR_UPGRADE_TYPE` CHANGE COLUMN `OBSERVE_NAME` `OBSERVE_NAME_ZH` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '升级方式名称-中文';
- ALTER TABLE `AR_UPGRADE_TYPE` ADD COLUMN `OBSERVE_NAME` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '升级方式名称' AFTER `ID`;
- UPDATE `AR_UPGRADE_TYPE` SET `OBSERVE_NAME` = 'filling up of a deficit' WHERE ID = '1001565409206640A2' LIMIT 1;
- UPDATE `AR_UPGRADE_TYPE` SET `OBSERVE_NAME` = 'full payment' WHERE ID = '1001565409206640E2' LIMIT 1;
|
