Question

mysql的一个数据库存储过程问题，希望有识之士为我尽快解答！在线等！

我写了这一段
SELECT COUNT(*) AS pcount
FROM mi_spare_table1
WHERE dealer_id = p_declareid AND spare_code = p_code;
但是在执行的过程中报错：
Procedure execution failed
1054 - Unknown column 'pcount' in 'field list'
p_declareid 跟p_code是我传进来的参数，
很奇怪啊，不该会这样的·····
了解细节的人快帮我解答一下！！！

Answer 1

先把pcount 定义一下

pcount INT;

然后sql里
SELECT COUNT(*) into pcount
FROM mi_spare_table1
WHERE dealer_id = p_declareid AND spare_code = p_code;