Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      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 rel="nofollow" style='text-decoration: none;' 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.

 >> 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
 >> Stay informed about: PERFORM statement 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Best way to issue hundreds of inserts/updates??? - Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of individual inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert..

MySQL freezes, brings XP machine to a grinding halt - I've been using MySQL for a while for fairly light database development on my XP machine. Currently, I am just starting a new project and have experienced some big problems with MySQL today both on my office machine and at home where running a particular...

login as user 'root' but do not have root privlages and my.. - Hi gang: I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0 to 4.1.10 and now when I login as root it doesn't show all the databases I should have access to, nor it doesn't recognize me being logged in as root (via..

FLUSH TABLES hangs if table is locked - Using FLUSH TABLES via the C query API mysql_query() hangs if the table is locked already. That is to say, nothing prevents me from running a LOCK TABLES twice; it won't tell me "it's already locked, don't try to run a FLUSH". Anyone know ...

Tool to convert DDL in graphical diagram? - Does anyone know of a tool that will create a graphical diagram from a DDL (SQL create script)? Preferable a free open-source tool. Thanks, A
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada)
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 ]