高手救命啊!
mysql存储过程中
select o.bank_id,o.ip_address,o.oper_psw,o.info_status,s.bank_status,s.oper_status
#into v_bank_id,v_ip_address,v_oper_psw,v_status,v_bank_status,v_oper_status
from oper_info o inner join (select l.oper_id,b.bank_status,
l.oper_status from oper_shift_log l inner join bank_def b on l.bank_id=b.bank_id) s on s.oper_id=o.oper_id where o.oper_id=oper_id;
#oper_id是传进来的值
在Console中报错
严重:Servlet.service() for servlet default threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'o' in field list
单独这个select语句 给oper_id一个值 放到命令提示符里面可以运行
但去调这个存储过程又会报错!
mysql> call t_procedure_log('','','','',@a);
ERROR 1109 (42S02): Unknown table 'o' in field list
求解!!!
|