数据库
法法-發發發
喜欢胡言乱语
展开
-
mysql5.6数据库忘记密码及修改密码
修改密码sql:update mysql.user set password=password('123456') where user='root';原创 2021-06-14 22:20:10 · 2643 阅读 · 1 评论 -
mysql8.0创建存储过程
执行多批量多表单条相同记录删除操作; DELIMITER // CREATE PROCEDURE del_user(IN userId BIGINT) BEGIN DELETE FROM `user` WHERE id = userId ; DELETE FROM `user_auths` WHERE user_id = userId ; DELETE FROM `user_approval_log` WHERE user_id = userId ; DELETE FROM `suser_extend`原创 2020-07-23 17:43:30 · 3917 阅读 · 1 评论