MYSQL 的常用操作

字符串前截掉

update Acr_Store set CarCodes= substring(CarCodes,2) where CarCodes like ';%';

字符串后截掉

update Acr_Store set CarCodes= left(CarCodes,length(CarCodes)-1) where
CarCodes like ‘%;’;

存储过程删除、创建

#先清理数据truncate table cache_base_datas;DELIMITER $$DROP PROCEDURE IF EXISTS CacheData$$create PROCEDURE CacheData()begin    DECLARE done INT DEFAULT FALSE;    DECLARE _outid INT;    DECLARE sor CURSOR     FOR     SELECT AcrStoreTypeId FROM Acr_Store_Type;    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;    OPEN sor;   read_loop: LOOP    FETCH sor INTO _outid;    IF done THEN      LEAVE read_loop;    END IF;    INSERT INTO cache_base_datas(`TableName`,`OperateType`,`DataId`,`ChangeTime`,`Remark`,`CacheType`)VALUES('Acr_Store_Type',0,_outid,now(),'','table');    END LOOP;    CLOSE sor ;  end$$          DELIMITER ;CALL CacheData;DROP PROCEDURE IF EXISTS CacheData;