Mysql 随笔

update aggregate_product set description=subString(description,1,300);
ALTER TABLE `aggregate_product`
CHANGE COLUMN `description` `description` VARCHAR(300) NULL DEFAULT NULL COMMENT ‘产品描述，来自产品‘ ,
DROP INDEX `IX_PRODUCT_THIRDNO` ,
ADD INDEX `IX_PRODUCT_THIRDNO` (`thirdNo` , `approveSort` , `uptime`) ;

Mysql 随笔

标签：