不过很明显的是
declare cur_dad cursor for select dad_id,remark from t_gpa where gpa_id=v_gpa_id;
declare continue handler for not found set v_sqlerr_dad = 1403;
不能写在存储过程的中间,必须在头部进行定义。//统计当天支出总额
$sql_out="select sum(cash) as cashout from my_money where time < $dayend and time > $daybegin and type=1 group by FROM_UNIXTIME(time,'%y-%m-%d')";
//统计当天收入总额
$sql_in="select sum(cash) as cashin from my_money where time < $dayend and time > $daybegin and type=2 group by FROM_UNIXTIME(time,'%y-%m-%d')";
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)