Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
September 26, 2006, 5:38 pm
rate this thread
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?
Re: IDE for stored procedures, are MySQL stored procedures reliable?
MySQL Query Browser. I use it here and it works well.
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.
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.
No problems, you're welcome! I hope I helped you a bit.
- » Temporary Table Accessable Only In Instance of Procedure
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum