mysql????????????????????????(1)??????mysql??????????????????????????????????????????????????????????????????????????????????????????:创建过程ProcedureName(Params[in,out])开始吗????????申报??attr attrType??????????过程
mysql????????????????????????(1)??????mysql??????????????????????????????????????????????????????????????????
????????????????????????:
创建过程ProcedureName(Params[in,out])
开始
????????申报??attr attrType
??????????程序内容;
结束;
沙奇霍科
示例:
1.????????????????????????
创建过程实例1()
begin
??????????声明l_student_count整数;
??????????select count(*)into l _ student _ count from student;
??
????????????select concat('总共有',l_student_count,'学生');
end;
沙奇霍科
2.??????????????????
????drop过程示例1;
沙奇霍科
3.??????????????????????????????
创建过程example 2(stu _ id int)
begin
??????声明stu _ name varchar(30);
??
????????select name into stu _ name from student,其中student _ id = stu _ id
????????选择stu _ name
end;
沙奇霍科
4.????????????????????????
create function example5()返回int
begin
????????声明student _ count int
??
??????????select count(*)into student _ count from student;
??????????返回student _ count
end;
沙奇霍科
5.???????????????????????????
在每行的update on t
begin
之前创建触发器example6????如果New.percent < 0,则
????????设置New.percent = 20
????Else
????????设置New.percent = 100
????结束If;
End;