mysql教程 存儲過程 incorrect number of arguments
DROP PROCEDURE `chaxun_name_ps教程`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `chaxun_name_ps`(in c_id
int,out c_phone char,out c_pwd char)
READS SQL DATA
begin
select phone,pwd
from caopanshou
where id = 18;
select found_rows() into c_phone,c_pwd;
end
調用方法
call chaxun_name_ps(1,1,1)
不知道 方法
select @chaxun_name_ps()
返回值為Null
有些朋友可能不知道found_rows()函數的功能
select count (*) from t 相同功能的mysql函數found_rows
<?php教程
$sql = "select count(*) from t";
$res = mysql_query($sql);
$num = mysql_result($res,0);
$sql = "select topic,detail from t limit 5";
//***以下我就不寫了
?>
然而用mysql自帶函數found_rows();