Question

mysql 创建存储过程报错！

mysql> create procedure aa()
-> BEGIN
-> declare v_count number;
-> FOR cur IN (SELECT * FROM Billinfo) LOOP INSERT INTO Billinfo_test VALUES cur;
-> v_count := v_count + 1;
-> IF v_count >= 1000 THEN
-> COMMIT;
-> END IF;
-> END LOOP;
-> COMMIT;
-> END
-> //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'number;
FOR cur IN (SELECT * FROM Billinfo) LOOP INSERT INTO Billinfo_test V' at line 3
求高手指教如何修改上面的创建存储过程语句。

Answer 1

1. v_count是number类型， 看数据库是mysql,应该是int之类的类型才对。
2. for cur IN, 这个不太理解是什么意思。如果是游标的话，声明和用法都不太对。

Answer 2

msql没有number吧，decimal

Answer 3

好像数据类型不是太对啊。