By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,823 Members | 730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,823 IT Pros & Developers. It's quick & easy.

IDE for stored procedures, are MySQL stored procedures reliable?

P: n/a
Hi,
I am trying to create stored procedures in MySQL. Does anyone have a
suggestion on a good IDE to use. I have been working with the MySQL
Query Browser but it generates errors very often and is shut down by
Windows. When I make changes to my procedure, it doesn't seem to
always change what is being executed. Furthermore, sometimes the
procedure just disappears from my database. I am starting to think
that the stored procedure language in MySQL is just not reliable. Am I
wrong on this?

Thanks,
Bob

Sep 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

bs********@yahoo.com wrote:
Hi,
I am trying to create stored procedures in MySQL. Does anyone have a
suggestion on a good IDE to use.
MySQL Query Browser. I use it here and it works well.
I have been working with the MySQL
Query Browser but it generates errors very often and is shut down by
Windows. When I make changes to my procedure, it doesn't seem to
always change what is being executed.
What version are you using? The latest on dev.mysql.com seems to be
MySQL GUI Tools 5.0-r4. I'm running 5.0-r3 here and the QB component is
at version 1.2.3 beta.

You might also look at MySQL Workbench. It's a powerful schema design
application, and it has tools to create stored procedures. It's called
"Routine group". I'm still very new to the workbench though, so I can't
give you some expert advice about it.
Furthermore, sometimes the
procedure just disappears from my database. I am starting to think
that the stored procedure language in MySQL is just not reliable. Am I
wrong on this?
Might be a problem with QB. I created some stored functions and
procedures a while back in my WWW logging database and they never
disappeared nor stopped functioning, so for me it seems the MySQL stored
procedure language is reliable.
>
Thanks,
Bob
No problems, you're welcome! I hope I helped you a bit.

Nicolas Laplante
Oct 4 '06 #2

P: n/a
Bob
Appreciate it. I'll try a newer QB version and the MySQL workbench
when I get back to the stored procedures.
Nicolas Laplante wrote:
bs********@yahoo.com wrote:
Hi,
I am trying to create stored procedures in MySQL. Does anyone have a
suggestion on a good IDE to use.

MySQL Query Browser. I use it here and it works well.
I have been working with the MySQL
Query Browser but it generates errors very often and is shut down by
Windows. When I make changes to my procedure, it doesn't seem to
always change what is being executed.

What version are you using? The latest on dev.mysql.com seems to be
MySQL GUI Tools 5.0-r4. I'm running 5.0-r3 here and the QB component is
at version 1.2.3 beta.

You might also look at MySQL Workbench. It's a powerful schema design
application, and it has tools to create stored procedures. It's called
"Routine group". I'm still very new to the workbench though, so I can't
give you some expert advice about it.
Furthermore, sometimes the
procedure just disappears from my database. I am starting to think
that the stored procedure language in MySQL is just not reliable. Am I
wrong on this?

Might be a problem with QB. I created some stored functions and
procedures a while back in my WWW logging database and they never
disappeared nor stopped functioning, so for me it seems the MySQL stored
procedure language is reliable.

Thanks,
Bob

No problems, you're welcome! I hope I helped you a bit.

Nicolas Laplante
Oct 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.