問題描述

要多次的執行一個select操作，就想著用循環來實現，在網上查了一些內容，顯示的做法都是差不多的，就是總是提示語言錯誤，很是郁悶，各位大俠幫忙看看，要怎么改才可以。mysql數據庫、navicat客戶端。mysql循環的操作語句：

procedure pro10()begindeclare i int; set i=0; while i<5 do select * from gamechannel where status=i GROUP BY gameId ; set i=i+1; end while;end;

錯誤信息：[SQL] procedure pro10()begindeclare i int;[Err] 1064 - 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 ’procedure pro10()begindeclare i int’ at line 1

問題解答

你這是再寫存儲過程嗎？1.創建存儲過程DELIMITER $$create procedure pro10()begindeclare i int; set i=0; while i<5 do

select * from gamechannel where status=i GROUP BY gameId ; set i=i+1;

end while;end;$$

2.調用call pro10()