默的博客

文章目录NoSql概述为什么要用NoSqlNoSQL的四大分类Redis入门概述Linux环境安装redis测试性能基础知识五大数据类型Redis-keyStringListSetHashZset(有序集合)三种特殊数据类型geospatial地理位置HyperloglogBitmap事务Jedis常用API通过Jedis再次理解事物SpringBoot整合RedisRedisUtil实战记录Spring缓存Redis缓存RedisConfig.javaRedis.conf详解Redis持久化RDB（Red

1、计算没有选课的学生人数，涉及到的表：student、sc --1、声明游标 declare num_cursor cursor for select sno from student for read only --2、打开游标 open num_cursor --声明变量 declare @sno char(20), @num int select @num = 0 --3、读取游标中的数据 fetch next from num_cursor into @sno while @@FETCH_ST

语法： create proc myproc as ... 例1：从SC表中查询不及格课程超过3门的学生信息 create proc myproc as select* from student where Sno in ( select sno from SC where Grade < 60 group by Sno having COUNT(*) > 3) exec myproc drop proc myproc ...