A brief example of the use of stored procedures and if statements in MySQL syntax

1 Create proceduregh () #注意各个地方的分号! This code should run the section that removes the last sentence, and then run call GH to display the results that have been stored2 BEGIN3 DeclareC_noint; #声明数据类型的方法4 5 Select Count(*) intoC_no # Depositing a result into a variable6  fromJYB7 whereJszhinch(8 SelectJszh9  fromDzbTen whereDw= 'Department of Economics'); One  A ifC_no= 0  Then#if...... Then......Else.....End if - SelectXm asName, DW asUnit, ZC asJob Title -  fromDzb the whereDw= 'Department of Economics'  and -  not exists ( - Select * -  fromJyb,dzb + whereDzb.jszh=Jyb.jszh andDw= 'Department of Economics'); -  + Else  A Select 'There are people in this department who haven't returned.'; #此处select相当于print at  - END if; - END -  -  -Call GH;

A brief example of the use of stored procedures and if statements in MySQL syntax