問題描述

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

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.創(chuàng)建存儲過程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.調(diào)用call pro10()