<![CDATA[孤城浪子的地盘]]> https://www.gclz.cn/index.php zh-cn https://www.gclz.cn/post// <![CDATA[Mysql 锁定某列值的存储过程，用于禁止修改密码]]> 孤城浪子 <admin@yourname.com> Wed, 05 Mar 2014 03:25:09 +0000 https://www.gclz.cn/post//
DELIMITER ;;
drop trigger if exists foo_upd;;
CREATE TRIGGER foo_upd BEFORE  UPDATE ON 表名 FOR EACH ROW
begin 
IF OLD.Password != NEW.Password THEN
set NEW.Password=OLD.Password ;
END IF;
END;;
DELIMITER ;

]]> https://www.gclz.cn/post//#blogcomment <![CDATA[[评论] Mysql 锁定某列值的存储过程，用于禁止修改密码]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://www.gclz.cn/post//#blogcomment