mysql笔记(三)-- 用户登录(二):保存用户操作日志的方法

BEGIN
    set @gid=0;
    set @user_name='';
    set @_result='login sucess';
    SELECT id,user_name INTO @gid,@user_name FROM user_sys WHERE user_name=_user_name AND user_pwd=_user_pwd LIMIT 1;
    
    IF @gid=0 THEN #登录不成功
        SET @_result='login error';
    END IF;
    INSERT INTO user_log(user_id,log_type) VALUES (@gid,@_result);  #<-写入日志表，这节课新增
    SELECT * FROM (SELECT @_result as _result) a,(SELECT @gid,@user_name) b;
        
    
END

BEGIN
    SET @num=1;
     WHILE @num<100000 DO
        INSERT INTO user_log(log_type,user_id) VALUES ('log success',floor(rand()*100000));
   END WHILE;

END;

SELECT a.user_name ,a.id,b.log_date FROM user_sys a,user_log b WHERE a.id=b.user_id order by b.id desc  limit 0,10;