创建dcs2表同时创建外键约束","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"0r8v-1660111496125","name":"paragraph","data":{},"nodes":[{"type":"text","id":"Dl8g-1660111496123","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ELSI-1660121886634","name":"paragraph","data":{},"nodes":[{"type":"text","id":"CBr0-1660121886632","leaves":[{"text":"如果dcs1和dcs2存在外键约束,dcs1(主表) dcs2(子表)","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"rcTN-1660121888622","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"54kG-1660121888621","leaves":[{"text":"主表中步存在的数据,不能在子表中进行插入","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"mqLz-1660111496430","name":"paragraph","data":{},"nodes":[{"type":"text","id":"wz2d-1660111496428","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ByZb-1660111496624","name":"paragraph","data":{},"nodes":[{"type":"text","id":"lEsO-1660111496621","leaves":[{"text":"删除数据","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"lwPJ-1660121923598","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Mnrm-1660121923597","leaves":[{"text":"delete from dcs1 where id=1;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"bA5b-1660121923600","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Rv0f-1660121923599","leaves":[{"text":"DELETE from dcs2 where sid=1;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"YAyc-1660121923602","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"3gcb-1660121923601","leaves":[{"text":"如果要删除主表的数据,需要先删除与主表相关的子表数据;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"NELz-1660121923604","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"1sm1-1660121923603","leaves":[{"text":"alter table dcs2 drop FOREIGN key xiaoliu;==>删除主键约束","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ECi6-1660111496841","name":"paragraph","data":{},"nodes":[{"type":"text","id":"5Mhb-1660111496839","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"gzDV-1660111497036","name":"paragraph","data":{},"nodes":[{"type":"text","id":"mDCO-1660111497034","leaves":[{"text":"存储过程","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"gNxT-1660111846388","name":"paragraph","data":{},"nodes":[{"type":"text","id":"KdIe-1660111846382","leaves":[{"text":"固定格式","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ydxJ-1660111878929","name":"paragraph","data":{},"nodes":[{"type":"text","id":"Ws05-1660111878928","leaves":[{"text":"create procedure 存储过程名称（参数名，数据类型） ==》创建存储过程","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"2aox-1660111925937","name":"paragraph","data":{},"nodes":[{"type":"text","id":"fqyK-1660111925936","leaves":[{"text":"begin ==》存储过程开始","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"1OsD-1660111949569","name":"paragraph","data":{},"nodes":[{"type":"text","id":"7igN-1660111949568","leaves":[{"text":"存储过程体","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"e6FR-1660111960507","name":"paragraph","data":{},"nodes":[{"type":"text","id":"kB0c-1660111960505","leaves":[{"text":"end ==》存储过程结束","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"49QC-1660111966243","name":"paragraph","data":{},"nodes":[{"type":"text","id":"CHN6-1660111966241","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"2120-1660111967552","name":"paragraph","data":{},"nodes":[{"type":"text","id":"HzF5-1660111967550","leaves":[{"text":"call 存储过程名称（） ==》调用存储过程","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"tgji-1660116111146","name":"paragraph","data":{},"nodes":[{"type":"text","id":"Hyd4-1660116111144","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"S35N-1660121963042","name":"paragraph","data":{},"nodes":[{"type":"text","id":"QUnZ-1660121963041","leaves":[{"text":"带参数查询","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"EeHn-1660116111618","name":"paragraph","data":{},"nodes":[{"type":"text","id":"uqm9-1660116111616","leaves":[{"text":"drop procedure if exists dcs18; ==》如果dcs18这个存储过程存在则删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"6BlQ-1660116113196","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"e18j-1660116113195","leaves":[{"text":"create procedure dcs18","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]},{"text":"(n int) #n是变量，int是数据类型","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"tqx8-1660116113198","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"bXSS-1660116113197","leaves":[{"text":"begin ==》存储过程开始","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"nzNo-1660116113201","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"2Bz3-1660116113199","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"1v8U-1660122174637","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"GWAd-1660122174636","leaves":[{"text":"sql集合","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"OS6p-1660122166532","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"bjlW-1660122166531","leaves":[{"text":"drop table if exists cc; 如果cc存在删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ZYh9-1660116113203","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"YoVN-1660116113202","leaves":[{"text":"create table cc(id int(5)primary key auto_increment,score int(5));","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Fbfq-1660116113205","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"xCtT-1660116113204","leaves":[{"text":"insert into cc values(1,88),(2,75);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"hb46-1660116113207","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"BFb1-1660116113206","leaves":[{"text":"insert into cc values(3,79),(4,95);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"DI0g-1660116113209","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"fvjo-1660116113208","leaves":[{"text":"insert into cc values(5,85),(6,63);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ZTvX-1660116113211","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"lJmm-1660116113210","leaves":[{"text":"select * from cc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"hMmM-1660116113213","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"liQ6-1660116113212","leaves":[{"text":"select * from cc where ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]},{"text":"id=n","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]},{"text":"; ==》带参数查询","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"FOqu-1660116113215","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"E6eq-1660116113214","leaves":[{"text":"end ==》存储过程结束","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ru7q-1660116113217","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"RLlP-1660116113216","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"A1md-1660116128714","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"RA49-1660116128713","leaves":[{"text":"call dcs18(n) #调用存储数据","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]},{"text":"（要查几n就是几）","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"aigp-1660116348993","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"7osO-1660116348991","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"Vap1-1660116349192","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"c2Xg-1660116349191","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"fL91-1660116349449","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"n8qi-1660116349447","leaves":[{"text":"if条件判断语句","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"CMvy-1660116374407","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"AsPL-1660116374405","leaves":[{"text":"单分支","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"R01B-1660116380983","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"pslT-1660116380981","leaves":[{"text":"if 条件 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Mt6y-1660116414321","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"na2k-1660116414319","leaves":[{"text":" sql语句1","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"KWa2-1660116427283","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"CQ6o-1660116427281","leaves":[{"text":"else","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"PxlE-1660116432801","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"1MJL-1660116432799","leaves":[{"text":" sql语句2","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"t9f1-1660116441222","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"zKMD-1660116441220","leaves":[{"text":"end if","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"F6Tc-1660116929659","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"kYvK-1660116929657","leaves":[{"text":" ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"0KhX-1660122069367","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"0GZP-1660122069365","leaves":[{"text":"单分支判断","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"XsBc-1660122071051","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"eKwj-1660122071050","leaves":[{"text":"drop procedure if exists dcs18;==》如果dcs18这个存储过程存在则删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ocjV-1660122071053","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"PBz6-1660122071052","leaves":[{"text":"create procedure dcs18(n int) ==》创建存储过程,n是变量 int是数据类型","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Op6u-1660122071055","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"xlzK-1660122071054","leaves":[{"text":"begin ==》存储过程开始","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"xEkr-1660116948827","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"zbzy-1660116948825","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Dczo-1660122128157","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"A9nK-1660122128155","leaves":[{"text":"if n=0 then \r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"CLvb-1660116932506","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Zswh-1660116932507","leaves":[{"text":" select count(*) from cc;\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"udrb-1660116932508","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"7sDO-1660116932509","leaves":[{"text":"else \r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"sMnT-1660116932510","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"dBt0-1660116932511","leaves":[{"text":" select * from cc order by score desc;\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ZUYh-1660116932512","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"kuL6-1660116932513","leaves":[{"text":"end if;","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"aQyb-1660122219814","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"7aNk-1660122219812","leaves":[{"text":"end # ==》存储过程结束","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Cokj-1660111497218","name":"paragraph","data":{},"nodes":[{"type":"text","id":"W8S8-1660111497215","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ogIH-1660116956300","name":"paragraph","data":{},"nodes":[{"type":"text","id":"rS5B-1660116956298","leaves":[{"text":"多分支","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#FF0001"}]}]}],"state":{}},{"type":"block","id":"FN7a-1660116975038","name":"paragraph","data":{},"nodes":[{"type":"text","id":"xQbj-1660116975035","leaves":[{"text":"if 条件1 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"4KGA-1660116992490","name":"paragraph","data":{},"nodes":[{"type":"text","id":"rhga-1660116992488","leaves":[{"text":" sql 语句1","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"jLj5-1660117000851","name":"paragraph","data":{},"nodes":[{"type":"text","id":"c6Ot-1660117000849","leaves":[{"text":"else if 条件2 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"knAm-1660117014034","name":"paragraph","data":{},"nodes":[{"type":"text","id":"J1s6-1660117014031","leaves":[{"text":" sql 语句2","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ddjh-1660117022128","name":"paragraph","data":{},"nodes":[{"type":"text","id":"4oSz-1660117022126","leaves":[{"text":"else if 条件3 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"y3jF-1660117057758","name":"paragraph","data":{},"nodes":[{"type":"text","id":"L4up-1660117057756","leaves":[{"text":" sql 语句3","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Nj6Z-1660117071148","name":"paragraph","data":{},"nodes":[{"type":"text","id":"cMQP-1660117071146","leaves":[{"text":"else","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Rwt2-1660117078411","name":"paragraph","data":{},"nodes":[{"type":"text","id":"Mrcq-1660117078410","leaves":[{"text":" sql 语句4","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"j1oU-1660117093685","name":"paragraph","data":{},"nodes":[{"type":"text","id":"FtJo-1660117093684","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"JCXp-1660117101835","name":"paragraph","data":{},"nodes":[{"type":"text","id":"tX6Y-1660117101833","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"RyjK-1660117106316","name":"paragraph","data":{},"nodes":[{"type":"text","id":"NdbQ-1660117106315","leaves":[{"text":"end if; ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"dhrO-1660117776612","name":"paragraph","data":{},"nodes":[{"type":"text","id":"gTBa-1660117776610","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"jo0m-1660117778070","name":"paragraph","data":{},"nodes":[{"type":"text","id":"ppJL-1660117778069","leaves":[{"text":"if n=0 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"7DrI-1660117779199","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"fosu-1660117779198","leaves":[{"text":"select count(*) from cc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"u0df-1660117779201","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"BKdr-1660117779200","leaves":[{"text":"else if n>0 and n<=6 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"bCV6-1660117779203","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"1IqZ-1660117779202","leaves":[{"text":"select * from cc order by score desc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"3Ul2-1660117779205","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"zR9g-1660117779204","leaves":[{"text":"else if n>6 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"fdYd-1660117779207","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"5qln-1660117779206","leaves":[{"text":"select max(score) from cc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Oi0G-1660117779209","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"XRJN-1660117779208","leaves":[{"text":"else","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"vQXZ-1660117779211","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"T48y-1660117779210","leaves":[{"text":"select * from cc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"0G6J-1660117779213","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"ajCS-1660117779212","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"gvdd-1660117779215","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"s2mn-1660117779214","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"tGza-1660117779217","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Ox5Q-1660117779216","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"swVz-1660118749161","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"u6ut-1660118749159","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"bH0a-1660118750608","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"VVzh-1660118750607","leaves":[{"text":"多分支判断\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"EO0W-1660122304994","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"noJu-1660122304995","leaves":[{"text":"drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"R77R-1660122304996","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"JKYv-1660122304997","leaves":[{"text":"create procedure dcs18(n int)#创建存储过程,n是变量 int是数据类型\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"0lfg-1660122304998","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"u7jE-1660122304999","leaves":[{"text":"begin#存储过程开始","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"LWnk-1660118750983","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"UCkE-1660118750981","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"k33i-1660122342626","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"2KAs-1660122342625","leaves":[{"text":"存储过程","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"y4xX-1660119274714","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"PsCo-1660119274712","leaves":[{"text":"declare i int(5)default(select count(*) from cc);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"agXF-1660119307146","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"bqX3-1660119307145","leaves":[{"text":" ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"uJx3-1660119308502","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"GFX4-1660119308500","leaves":[{"text":"循环","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"HPyS-1660122390075","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"6G8o-1660122390073","leaves":[{"text":"注意：","marks":[{"type":"color","value":"#FF0001"},{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"}]}]}],"state":{}},{"type":"block","id":"U61q-1660122391537","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"7Uct-1660122391536","leaves":[{"text":"什么时候进入循环：当条件成立时，进入循环","marks":[{"type":"color","value":"#FF0001"},{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"}]}]}],"state":{}},{"type":"block","id":"Hopq-1660122391539","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"U2bB-1660122391538","leaves":[{"text":"什么时候退出循环：当条件不成立时，退出循环","marks":[{"type":"color","value":"#FF0001"},{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"}]}]}],"state":{}},{"type":"block","id":"hHoL-1660122474172","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"cRtz-1660122474170","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"BfXZ-1660119339527","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"NEK1-1660119339525","leaves":[{"text":"while语句的格式： ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"nJlV-1660119362962","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"mjUL-1660119362960","leaves":[{"text":"while 条件 do","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"pJ06-1660122527993","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"yaGm-1660122527991","leaves":[{"text":" 执行循环体（sql）","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"W3T7-1660122540988","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"MNJt-1660122540987","leaves":[{"text":"end while","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"jYSw-1660119372282","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"h9Fv-1660119372280","leaves":[{"text":" ","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"aCO6-1660122554419","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"N0kL-1660122554417","leaves":[{"text":"drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"aQZB-1660122554579","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"G0JG-1660122554578","leaves":[{"text":"declare i int(5)default(select count(*) from cc);#declare声明变量i 默认值为表的行数","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"TNNw-1660122679884","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"pWyM-1660122679883","leaves":[{"text":"/*drop table if exists cc;#如果cc存在删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ILZU-1660122602043","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"KSSq-1660122602041","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"k1LF-1660122762744","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"9icr-1660122762742","leaves":[{"text":"declare i int(5)default(select count(*) from cc)","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"lfFc-1660122559445","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"pAe5-1660122559444","leaves":[{"text":"if n=0 then \r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"VuUy-1660120574303","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"faX2-1660120574304","leaves":[{"text":" select count(*) from cc;\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"7gh3-1660120574305","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"oQvf-1660120574306","leaves":[{"text":"else if n>0 and n<=i then \r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ndot-1660120574307","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"ZPFg-1660120574308","leaves":[{"text":" select * from cc order by score desc;\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"Cqyg-1660120574310","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"GJLp-1660120574311","leaves":[{"text":"else\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"axdk-1660120574312","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"KvZE-1660120574313","leaves":[{"text":" while n>i do\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"2yeo-1660120574314","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"tEru-1660120574315","leaves":[{"text":" insert into cc(score)values(88);\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"5sBs-1660120574316","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"6d0F-1660120574317","leaves":[{"text":" set i=i+1;\r","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"24Qb-1660120574318","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"VKuI-1660120574319","leaves":[{"text":" end while;","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"EbZL-1660121666964","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"K9lH-1660121666962","leaves":[{"text":"","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"vomG-1660121683235","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"8w3Y-1660121683233","leaves":[{"text":"if n=0 then\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"CDIt-1660121684779","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"PqvY-1660121684780","leaves":[{"text":" select count(*)from aa;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"FeZF-1660121684781","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"RZYV-1660121684782","leaves":[{"text":"else if n>0 and n<=i then\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"h6UW-1660121684783","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"I2Yu-1660121684784","leaves":[{"text":" select * from aa order by score desc;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"NFkk-1660121684785","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Pwp4-1660121684786","leaves":[{"text":"else\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"oSrQ-1660121684787","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"hegG-1660121684788","leaves":[{"text":" while n>i do\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"aFUr-1660121684789","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"etWv-1660121684790","leaves":[{"text":" set max=max+1;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"PKFZ-1660121684791","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"CvUn-1660121684792","leaves":[{"text":" insert into aa(score)values(max);\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"ajpI-1660121684793","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"KFan-1660121684794","leaves":[{"text":" set i=i+1;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"xefP-1660121684795","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"BYnu-1660121684796","leaves":[{"text":" end while;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"VQwK-1660121684797","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"fuZi-1660121684798","leaves":[{"text":"end if;\r","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"aC6g-1660121684799","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"RfKq-1660121684800","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"QOv0-1660121667570","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"1J3h-1660121667568","leaves":[{"text":"","marks":[{"type":"fontSize","value":16},{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"bold"},{"type":"color","value":"#000000"}]}]}],"state":{}},{"type":"block","id":"H2Vm-1660119279640","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"vbbJ-1660119279638","leaves":[{"text":"","marks":[]}]}],"state":{}},{"type":"block","id":"RdXD-1660122986677","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"bQg4-1660122986676","leaves":[{"text":"drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"MQzH-1660123103040","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"VVP4-1660123103039","leaves":[{"text":"create procedure dcs18(n int)#创建存储过程,n是变量 int是数据类型","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"pQ3A-1660123103042","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"QkWN-1660123103041","leaves":[{"text":"begin#存储过程开始","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"2JyM-1660123103045","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"poUG-1660123103044","leaves":[{"text":"#sql集合","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"stun-1660123103047","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Squ7-1660123103046","leaves":[{"text":"declare i int(5)default(select count(*) from aa);#declare声明变量i 默认值为表的行数","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"hrtb-1660123103049","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Fjze-1660123103048","leaves":[{"text":"declare max int(5)default(select max(score) from aa);#最高分数变量","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"38Tj-1660123103051","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"9w8a-1660123103050","leaves":[{"text":"/*drop table if exists aa;#如果aa存在删除","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"HS4O-1660123103053","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Ntib-1660123103052","leaves":[{"text":"create table aa(id int(5)primary key auto_increment,score int(5));","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"8OpK-1660122986859","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"3z25-1660122986858","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"I1PV-1660122987043","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"veqW-1660122987041","leaves":[{"text":"","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"1oKS-1660123118854","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"ZhCs-1660123118853","leaves":[{"text":"drop procedure if exists dcs18;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"ZnqG-1660122988593","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"TItN-1660122988592","leaves":[{"text":"create procedure dcs18(n int) #n是变量，int是数据类型","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"8nWu-1660122988595","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"pbB9-1660122988594","leaves":[{"text":"begin","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"oJhf-1660122988597","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"gNKe-1660122988596","leaves":[{"text":"declare i int(5)default(select count() from cc);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"law3-1660123158122","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"AKst-1660123158120","leaves":[{"text":"declare max int(5)default(select max(score)from cc);#declare声明变量，默认值为表的数据行数","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Zi01-1660123177743","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"ORvx-1660123177741","leaves":[{"text":"drop table if exists cc;create table cc(id int(5)primary key auto_increment,score int(5));insert into cc values(1,88),(2,75);insert into cc values(3,79),(4,95);insert into cc values(5,85),(6,63);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"rKdr-1660123190429","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"VYg6-1660123190427","leaves":[{"text":"if n=0 then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"5aq4-1660123219399","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"xiBX-1660123219397","leaves":[{"text":" select count() from cc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"740w-1660122988599","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"ViAb-1660122988598","leaves":[{"text":"else if n>0 and n<=i then","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"xpUD-1660122988601","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"xWAh-1660122988600","leaves":[{"text":" select * from cc order by score desc;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"jTul-1660122988604","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"eGzf-1660122988603","leaves":[{"text":"else","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Ukh8-1660122988606","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Ozcw-1660122988605","leaves":[{"text":" while n>i do","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"BV7c-1660122988608","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"Rb2J-1660122988607","leaves":[{"text":" set max=max+1;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Ro5P-1660122988610","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"gGAp-1660122988609","leaves":[{"text":" insert into cc(score)values(max);","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"4nsX-1660122988612","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"CyJu-1660122988611","leaves":[{"text":" set i=i+1;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Ux9N-1660122988614","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"fgDY-1660122988613","leaves":[{"text":" end while;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"RMXl-1660122988616","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"0Vxl-1660122988615","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Uv8h-1660122988618","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"MayC-1660122988617","leaves":[{"text":"end if;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"Sn9e-1660122988620","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"8ENN-1660122988619","leaves":[{"text":"end;","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"aBfc-1660122988622","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"1NVK-1660122988621","leaves":[{"text":"call dcs18(19) #调用存储数据","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"2Mst-1660122988624","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"YfUR-1660122988623","leaves":[{"text":"select count(*) from cc","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"kHk2-1660122988626","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"rhH9-1660122988625","leaves":[{"text":"select max(score) from cc","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}},{"type":"block","id":"24M4-1660122988628","name":"paragraph","data":{"version":1},"nodes":[{"type":"text","id":"IhwR-1660122988627","leaves":[{"text":"select * from cc","marks":[{"type":"fontFamily","value":"KaiTi_GB2312"},{"type":"fontSize","value":16},{"type":"bold"}]}]}],"state":{}}]'>索引
是一种数据结构
可以利用索引快速访问数据库中的特定信息
普通索引
show index from emp ==》查看索引
create index A on emp(sid) ==》为emp表中的sid创建一个索引A
create index B on emp(sid,name) ==》为emp表中的sid，name创建一个索引B
alter table emp drop index A ==》删除索引
唯一索引（对应的字段的值必须是唯一的，但允许有空值）
create unique index zz on emp(sid) ==》创建唯一索引
主键索引（和主键约束相辅相成）
添加一个主键约束就是添加主键索引，主键索引就是主键约束
alter table emp drop PRIMARY key;
show index from emp;
desc emp;
数据库视图
1.试图是由基本表产生的虚表
2.试图的更新和删除会影响基础表
3.基础表的更新和删除也会影响到试图
create view dcs as(select sid,name,age from emp); ==》 创建视图
select * from dcs;
update dcs set name='zhangsan' where sid=1789; ==》修改视图数据
update emp set name='张三' where sid=1789; ==》修改基本表数据
drop view dcs; ==》删除视图
DDL:数据库定义语言（对表和表结构操作）
create
alter table
drop
DML:数据库操作语言（表数据操作）
insert into
delete
update
select
数据库约束
not null ==》非空约束
primary key ==》主键约束
auto_incremet ==》自增长约束
default ==》默认值约束
前四种都是对表结构的约束
foreigin key ==》外键约束（对表与表之间的约束）
作用：保持数据的一致性，完整性
show create table dcs1 ==》查看建表语句
create table dcs1(id int(5)PRIMARY key,name varchar(10))ENGINE=innodb; ==》创建dcs1表，修改类型为innodb
CREATE table dcs2(sid int(5)PRIMARY key,sname varchar(10),CONSTRAINT xiaoliu foreign key dcs2(sid) REFERENCES dcs1(id))ENGINE=INNODB; ==>创建dcs2表同时创建外键约束
如果dcs1和dcs2存在外键约束,dcs1(主表) dcs2(子表)
主表中步存在的数据,不能在子表中进行插入
删除数据
delete from dcs1 where id=1;
DELETE from dcs2 where sid=1;
如果要删除主表的数据,需要先删除与主表相关的子表数据;
alter table dcs2 drop FOREIGN key xiaoliu;==>删除主键约束
存储过程
固定格式
create procedure 存储过程名称（参数名，数据类型） ==》创建存储过程
begin ==》存储过程开始
存储过程体
end ==》存储过程结束
call 存储过程名称（） ==》调用存储过程
带参数查询
drop procedure if exists dcs18; ==》如果dcs18这个存储过程存在则删除
create procedure dcs18(n int) #n是变量，int是数据类型
begin ==》存储过程开始
sql集合
drop table if exists cc; 如果cc存在删除
create table cc(id int(5)primary key auto_increment,score int(5));
insert into cc values(1,88),(2,75);
insert into cc values(3,79),(4,95);
insert into cc values(5,85),(6,63);
select * from cc;
select * from cc where id=n; ==》带参数查询
end ==》存储过程结束
call dcs18(n) #调用存储数据（要查几n就是几）
if条件判断语句
单分支
if 条件 then
sql语句1
else
sql语句2
end if
单分支判断
drop procedure if exists dcs18;==》如果dcs18这个存储过程存在则删除
create procedure dcs18(n int) ==》创建存储过程,n是变量 int是数据类型
begin ==》存储过程开始
if n=0 then
select count(*) from cc;
else
select * from cc order by score desc;
end if;
end # ==》存储过程结束
多分支
if 条件1 then
sql 语句1
else if 条件2 then
sql 语句2
else if 条件3 then
sql 语句3
else
sql 语句4
end if;
end if;
end if;
if n=0 then
select count(*) from cc;
else if n>0 and n<=6 then
select * from cc order by score desc;
else if n>6 then
select max(score) from cc;
else
select * from cc;
end if;
end if;
end if;
多分支判断
drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除
create procedure dcs18(n int)#创建存储过程,n是变量 int是数据类型
begin#存储过程开始
存储过程
declare i int(5)default(select count(*) from cc);
循环
注意：
什么时候进入循环：当条件成立时，进入循环
什么时候退出循环：当条件不成立时，退出循环
while语句的格式：
while 条件 do
执行循环体（sql）
end while
drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除
declare i int(5)default(select count(*) from cc);#declare声明变量i 默认值为表的行数
/*drop table if exists cc;#如果cc存在删除
declare i int(5)default(select count(*) from cc)
if n=0 then
select count(*) from cc;
else if n>0 and n<=i then
select * from cc order by score desc;
else
while n>i do
insert into cc(score)values(88);
set i=i+1;
end while;
if n=0 then
select count(*)from aa;
else if n>0 and n<=i then
select * from aa order by score desc;
else
while n>i do
set max=max+1;
insert into aa(score)values(max);
set i=i+1;
end while;
end if;
end if;
drop procedure if exists dcs18;#如果dcs18这个存储过程存在则删除
create procedure dcs18(n int)#创建存储过程,n是变量 int是数据类型
begin#存储过程开始
#sql集合
declare i int(5)default(select count(*) from aa);#declare声明变量i 默认值为表的行数
declare max int(5)default(select max(score) from aa);#最高分数变量
/*drop table if exists aa;#如果aa存在删除
create table aa(id int(5)primary key auto_increment,score int(5));
drop procedure if exists dcs18;
create procedure dcs18(n int) #n是变量，int是数据类型
begin
declare i int(5)default(select count() from cc);
declare max int(5)default(select max(score)from cc);#declare声明变量，默认值为表的数据行数
drop table if exists cc;create table cc(id int(5)primary key auto_increment,score int(5));insert into cc values(1,88),(2,75);insert into cc values(3,79),(4,95);insert into cc values(5,85),(6,63);
if n=0 then
select count() from cc;
else if n>0 and n<=i then
select * from cc order by score desc;
else
while n>i do
set max=max+1;
insert into cc(score)values(max);
set i=i+1;
end while;
end if;
end if;
end;
call dcs18(19) #调用存储数据
select count(*) from cc
select max(score) from cc
select * from cc
|
|
179
0
多测师社区 
