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:

http://datacharmer.blogspot.com/2007/08/boost-your-sql-with-proxy-loops.html

Examples:

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
http://dev.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Boost your SQL with Proxy loops
2927
August 12, 2007 02:16PM
2139
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.