1. 创建stored procedure
delimiter //
create procedure retval(in c int)
begin
select * from users where id=c;
end //
delimiter ;
2. 从php调用
17 $id = 3;
18 $cmd=Yii::app()->db->createCommand('call retval(' . $id . ')');
19 $rows=$cmd->queryAll();
20 foreach( $rows as $row )
21 {
22 echo $row['id'] . '-' . $row['username'];
23 }