MySQL Forums
Forum List  »  Router & Proxy

Boost your SQL with Proxy loops
Posted by: Giuseppe Maxia
Date: August 12, 2007 02:16PM

Now you can do loops using a Proxy script:


FOR 1 10 CREATE procedure p$N () select "hello from procedure # $N!";

FOR myvar ( Huey, Dewey, Louie ) CREATE procedure nephew_$myvar ()
SELECT "nephew #$N: $myvar" as nephew;

Giuseppe Maxia, MySQL Community Team Leader at Oracle

Options: ReplyQuote

Written By
Boost your SQL with Proxy loops
August 12, 2007 02:16PM
August 13, 2007 04:06AM

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.