我创建了一个简单的存储过程,成功了,但是在call执行调用的时候怎么老是报错呢?求高手
mysql> delimiter //
mysql> create procedure proprice()
-> begin
-> select avg(price) as average from products;
-> end//
Query OK, 0 rows affected (0.02 sec)mysql> delimiter ;错误:
mysql> call proprice();
ERROR 1457 (HY000): Failed to load routine test.proprice. The table mysql.proc i
s missing, corrupt, or contains bad data (internal code -5)
mysql> delimiter //
mysql> create procedure proprice()
-> begin
-> select avg(price) as average from products;
-> end//
Query OK, 0 rows affected (0.02 sec)mysql> delimiter ;错误:
mysql> call proprice();
ERROR 1457 (HY000): Failed to load routine test.proprice. The table mysql.proc i
s missing, corrupt, or contains bad data (internal code -5)
没有数据的原因吧
+---------+
| average |
+---------+
| 15.2625 |
+---------+
1 row in set (0.04 sec)
+---------+
| average |
+---------+
| 15.2625 |
+---------+
1 row in set (0.04 sec)
+-------+
| price |
+-------+
| 1 |
| 2 |
+-------+
2 rows in set (0.00 sec)
mysql> call proprice();
+---------+
| average |
+---------+
| 1.5000 |
+---------+
1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)过程可以执行 楼主 最好贴出数据