473,224 Members | 1,341 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

IDE for stored procedures, are MySQL stored procedures reliable?

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
2 6082

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Charles Parker | last post by:
Does MySQL have support for calling functions in C/C++ DLLs from trigger scripts similar to the Extended Stored Procedures functionality provided in SQL Sever? Thanks. Charles... -- MySQL...
0
by: Chrisbarbers | last post by:
--part1_108.256bef7d.2c5af59f_boundary Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hi =A0 I have purchased a package that uses ASP and SQL,...
3
by: Ben | last post by:
Dear MySQL experts, I have a website that is using MS SQL Server 2000 with ASP scripting. I want to switch over to MySQL, but I'm just sticking my toes in the water at the moment to see if it...
3
by: Marty | last post by:
Is there an issue with stored procedure and mySQL v5.0.18 ? We are programming an application that need stored procedures and triggers and our programmer can't make them work, is it a know issue...
1
by: E.T. Grey | last post by:
Hi All, Despite spending the past six to seven hours perusing the docs on the mySQl site, I still have questions unanswered, and have been unable to get any help. I am familiar with Sybase, some...
1
by: Radhakrishnans | last post by:
hai friends i am new to java and mysql.i have created stored procedures in mysql.Now i want to call that stored procedures in java.All works fine.but it show the following error. unreported...
0
by: Bruno Barberi Gnecco | last post by:
I'm using stored procedures in a PHP site, with mysql. I'm having problems with stored procedures. Of the two I'm using, one works all the time, consistently. The other works correctly, but the...
7
by: eholz1 | last post by:
Hello PHP group, Could someone help me out? I have PHP 5.2, Apache 2.0, and MySQL 5.0 running on Linux (Redhat Fedora Core 6). All that works fine. I would like to be able to "call" a stored...
1
by: Muhammad Intikhab Qaiser | last post by:
Hi I am developing a parser to parse the stored procedure and function definition of MySQL.I need to extract the names of stored procedures,functions and tables which are being used in any...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.