Mysql存储过程和函数
需积分: 17 14 浏览量
2012-03-26
17:24:38
上传
评论 1
收藏 176KB DOC 举报
创建存储过程或函数的语法：
Create procedure sp_name ([proc_parameter])
[characteristic] routine_body
Create function sp_name ([func_parameter])
Return type
[characteristic] routine_body
实例：
mysql> use test;
Database changed
Mysql -> create table xiaozhe(
-> id int primary key auto_increment,
-> name varchar(10)
-> );
Query OK, 0 rows affected (0.20 sec)
Mysql -> insert into xiaozhe(name) values('xiao');
Query OK, 1 row affected (0.08 sec)
Mysql -> insert into xiaozhe(name) values('zhe');
评论0