mysql????????????????????????(???)??????
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql????????????????????????(???)??????,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1520字,纯文字阅读大概需要3分钟。
内容图文
![mysql????????????????????????(???)??????](/upload/InfoBanner/zyjiaocheng/560/1fa76737b68a4a3099b1f7e0807da966.jpg)
mysql ????????????????????????(1)?????? mysql?????????????????????????????????????????????????????????????????? ????????????????????????: Create procedure ProcedureName(Params[in,out]) Begin ???????? Declare?? attr attrType; ??????????proce
mysql ????????????????????????(1)??????mysql??????????????????????????????????????????????????????????????????
????????????????????????:
Create procedure ProcedureName(Params[in,out])
Begin
???????? Declare?? attr attrType;
??????????procedure content;
End;
??
Example:
1. ????????????????????????
create procedure exampe1()
begin
?????????? declare l_student_count integer;
?????????? select count(*) into l_student_count from student;
??
?????????? ??select concat('there are totally ', l_student_count ,' students');
end;
??
2.??????????????????
???? drop procedure example1;
??
3.??????????????????????????????
create procedure example2(stu_id int)
begin
?????? declare stu_name varchar(30);
??
???????? select name into stu_name from student where student_id = stu_id;
???????? select stu_name;
end;
??
4.????????????????????????
create function example5() returns int
begin
???????? declare student_count int;
??
?????????? select count(*) into student_count from student;
?????????? return student_count;
end;
??
5.???????????????????????????
create trigger example6 before update on t for each row
begin
???? If New.percent < 0 then
???? ????set New.percent = 20;
???? Else
???? ????set New.percent = 100;
???? End If;
End;
内容总结
以上是互联网集市为您收集整理的mysql????????????????????????(???)??????全部内容,希望文章能够帮你解决mysql????????????????????????(???)??????所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。