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
