distal-attribute
distal-attribute
distal-attribute
distal-attribute

stored procedure support

User, date Message
Written by sharique
5 years ago
Category: Feature discussion
1 posts since Thu, 28 Feb 08
What are the plans for implementing stored procedure and triggers support?
---
Sharique
Written by rosenfield
5 years ago
127 posts since Wed, 24 Jan 07
Stored procedures are still at a pretty lame stage in MySQL.

For example, you can't create a procedure that takes a set of rows as input and produces a set of rows as output.

Lots of other examples of missing basic features.

I guess none of the HeidiSQL developers has seen MySQL SPs as useful enough to apply in their own projects, and therefore they have no need to implement support in the HeidiSQL client either.

(Out of curiosity, what do you use stored procedures for?)
Written by 4ndy
5 years ago
4 posts since Mon, 08 Jun 09
Stored Procedures was included and supported by MySQL since v5.0 I think?
Anywho, I use stored procedures for e.g. myDBR and report generation from various web applications and for automation of reporting. I see this becomming more and more common nowdays.

This is one of the features I really miss in HeidiSQL along with tab'ed connections (multiple DB connections in one instance). A extended DBA module is also on my wishlist, make these 3 things come true and you will be the #1 choice of all DBdevs, DBAs etc. for MySQL!

I would recommend a quick view of a Quest Toad for Oracle trial to get some inspiration around tab'ed connections and/or triggers/stored procedures. They did a great job with their Oracle client. Copy with pride :)

Thanks for a great MySQL Client!
Written by ansgar
5 years ago
4793 posts since Fri, 07 Apr 06
Stored procedures and functions are editable via dialog since HeidiSQL 4. Triggers not yet, but already requested here.
Written by 4ndy
5 years ago
4 posts since Mon, 08 Jun 09
How great! That is relly good news.
Sorry for not checking up the latest features first.

How about the tabbed connections in one program instance?

[size=9:1e7a6fb56e]Kudos to you for the best MySQL client available.[/size:1e7a6fb56e]
 

Please login to leave a reply, or register at first.