常用sql

查询数据库重复数值 ：SELECT * FROM `base_platform_goods` group by goods_code ,platform_type HAVING count( * )>1 ; 

 

插入平台索引： ALTER TABLE `base_platform_goods`

ADD UNIQUE INDEX `goods_code_platform_type` (`goods_code`, `platform_type`) USING BTREE ; 

首写字母 小写变 大写

update goods_sku set sku=concat(UPPER(left(sku,1)),substring(sku,2,(length(sku)-1)))  where sku REGEXP BINARY '[a-z]';

 

批量更改字段

 

UPDATE TABLE SET COLUMN = REPLACE(COLUMN,'img.caixuan.com//upload','img.caixuan.com/image/web/upload') WHERE 1=1;

 

空值 NULL

 

UPDATE `base_goods`

SET goods_aliases_name = replace(goods_aliases_name, '富安娜', '')

WHERE

goods_aliases_name LIKE ('%富安娜%');