Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

PERFORM statement

 
   Database Help (Home) -> mySQL RSS
Next:  mysql 3.23 datatime problem  
Author Message
nobody30

External


Since: Jan 15, 2005
Posts: 15



(Msg. 1) Posted: Sat Feb 19, 2005 10:31 am
Post subject: PERFORM statement
Archived from groups: mailing>database>mysql (more info?)

is there an equivalent of postgresql's PERFORM statement in mysql?

 >> Stay informed about: PERFORM statement 
Back to top
Login to vote
Bill Karwin1

External


Since: Jun 17, 2004
Posts: 42



(Msg. 2) Posted: Sat Feb 19, 2005 10:31 am
Post subject: Re: PERFORM statement [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

- wrote:
 > is there an equivalent of postgresql's PERFORM statement in mysql?

As far as I can tell, this is part of Postgresql's proprietary stored
procedure language. I'm not a Postgresql user, so on first glance at
docs the closest match I can come up with is the CALL statement in MySQL
5.0 stored procedure language.
<a style='text-decoration: underline;' href="http://dev.mysql.com/doc/mysql/en/call.html" target="_blank">http://dev.mysql.com/doc/mysql/en/call.html</a>

Why don't you describe what you're trying to do and perhaps someone can
offer advice on how best to do it with MySQL?

Regards,
Bill K.<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: PERFORM statement 
Back to top
Login to vote
user

External


Since: Feb 18, 2005
Posts: 8



(Msg. 3) Posted: Sun Feb 20, 2005 12:17 am
Post subject: Re: PERFORM statement [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Bill Karwin wrote:
 >
 > Why don't you describe what you're trying to do and perhaps someone can
 > offer advice on how best to do it with MySQL?

i have several statements inside a procedure and want to return the
ROW_COUNT() of the first statment. so in postgresql i can do a perform
for all statements except the first.

this can be easily solved by storing the value into a variable. having a
Perform statement looks neater, though. Smile<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: PERFORM statement 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]