MySQL Forums
Forum List  »  Turkish

LIMIT problemi
Posted by: namco0088 namco0088
Date: September 17, 2010 12:45AM

Merhaba arkadaslar.....
mysql procedure icinde asagidaki kodda problem var....
hata veriyor....
bunu nasil coze bilirim....
set @i = 0;
while @i < 10 do
select name,surname from tbl_persons where age > 20 limit @i,1;
set @i = @i + 1;
end while;
HAta mesaji
You have an error in your SQL syntax...near @i,1;
set @i = @i + 1;
end while;

Options: ReplyQuote

Written By
LIMIT problemi
September 17, 2010 12:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.