mysql存储过程

1.建表

CREATE TABLE 'user' (
'id' int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto_increment id',
'username' varchar(200) NOT NULL,
'sex' char(2) NOT NULL,
PRIMARY KEY ('id')
)

2.新建存储过程

delimiter $$　
 create procedure insertuserproce(in usernamestr varchar(1000))
 begin
 INSERT INTO user (id, username, sex) VALUES (NULL, usernamestr, '0');
 END;
$$

delimiter $$
create procedure setscore(out score int)
begin
set score=100;
end;
$$

3.mysql使用存储过程

<?php
$con = mysql_connect('127.0.0.1','root','987@wuyou2003.com') or die('数据连接错误!!');
mysql_select_db('fwbtest',$con);
$sql = "delete from user where username='proceuser';";
mysql_query($sql);
//1
$sql = "call insertuserproce('proceuser');";
mysql_query($sql);//调用myproce的存储过程，则数据库中将增加一条新记录。
//2
$sql = 'call setscore(@score);';
mysql_query($sql);//调用myproce3的存储过程
$result = mysql_query('select @score ;');
while($row = mysql_fetch_assoc($result)){
  $arrReturn[] = $row;
}
var_dump($arrReturn);


$dbname ='fwbtest';
if ($con) {
  if (mysql_select_db($dbname, $con)) {
    $sql ='select * from user where username ="proceuser";';
    $ret = mysql_query($sql);
    while($row = mysql_fetch_assoc($ret)){
      $info[] = $row;
    }
    var_dump($info);
  }
}
mysql_close($con);