脚踏实地、勇往直前！
全部博文（1005）
发布时间：2018-06-11 20:16:29
1.创建表并写入测试数据create table tb_rank_score( city varchar(20), score int);insert into tb_rank_score values('sz',89);insert into tb_rank_score values('sz',76);insert into tb_rank_score values('sz',50);insert into tb_rank_score values('sz',89);insert into tb_rank_score .........【阅读全文】
发布时间：2014-08-01 16:33:49
1.loop-loop嵌套CREATE PROCEDURE hxl.sp_loop_loop()BEGIN DECLARE l_class_id int; DECLARE l_class_name varchar(20); DECLARE l_student_id int; DECLARE l_student_name varchar(20); DECLARE done int; DECLARE cur_out CURSOR FOR SELECT &nb.........【阅读全文】
