mysql 存储过程遍历结果集
DELIMITER // create PROCEDURE updatecatalog() begin declare s id int default 0; declare r number bigint default 0; decla…
记录学习和工作
DELIMITER // create PROCEDURE updatecatalog() begin declare s id int default 0; declare r number bigint default 0; decla…
ErrorLog "| /opt/lampp/bin/rotatelogs /opt/lampp/logs/aaa %Y%m%d error log 86400 480" CustomLog "| /opt/lampp//bin/rotat…
禁止更新xxx xx表的password字段 CREATE TRIGGER xxx xx update(触发器名称) BEFORE UPDATE ON xxx xx(表名) FOR EACH ROW BEGIN IF OLD.passwor…
https://blog.csdn.net/qq 15766181/article/details/75646717 https://www.itsource.cn/web/news/2040.html https://www.cnblog…