Menu

#420 Creating and editing stored procedures/functions

Fixed
nobody
None
Default
Enhancement
2009-03-02
2008-05-27
Anonymous
No

Originally created by: a...@anse.de
Originally owned by: a...@anse.de

Reported as bug #1642626 by nobody@sf on 2007-01-23 07:23

It would be great if HeidiSQL had a nice view of existing stored procedures
together with a comfortable way to create and edit them.

**** Comment 1 by homncruse@sf, 2008-05-07 12:40

Seconded. As the database world progresses, stored procedures are becoming
more and more common - in my opinion, this is the ONE feature which
prevents HeidiSQL from being a one-stop MySQL resource.

Related

Tickets: #364
Tickets: #507
Tickets: #869

Discussion

  • Anonymous

    Anonymous - 2008-05-28

    Originally posted by: rosenfie...@gmail.com

    (No comment was entered for this change.)

    Labels: -priority-default Severity-Default

     
  • Anonymous

    Anonymous - 2008-05-30

    Originally posted by: a...@anse.de

    (No comment was entered for this change.)

    Labels: -migrated

     
  • Anonymous

    Anonymous - 2008-10-30

    Originally posted by: fbar...@gmail.com

    The developers may put a scheduler function to send mail with the results of procedures.

     
  • Anonymous

    Anonymous - 2008-10-30

    Originally posted by: rosenfie...@gmail.com

    cute.  what would you use that for?

     
  • Anonymous

    Anonymous - 2008-11-18

    Originally posted by: frank.pa...@gmail.com

    I agree, HeidiSQL is very good (perhaps the best?), but we have a lot of stored
    procedures to maintain and have to rely on other tools for that.

     
  • Anonymous

    Anonymous - 2009-01-21

    Originally posted by: a...@anse.de

    If you want to vote for an enhancement, just click the yellow star here. So the
    developers can see how important that is to users.

     
  • Anonymous

    Anonymous - 2009-02-06

    Originally posted by: Spast...@gmail.com

    I just downloaded HeidiSQL after having trouble with EMS's MyManager for the
    umpteenth time. I like the interface and all the functionality I quickly checked
    seemed easy to use and easy to find. But, alas, a storproc functionality would be
    great. We use storprocs extensively as well. MyManager handles them well.

     
  • Anonymous

    Anonymous - 2009-02-23

    Originally posted by: a...@anse.de

    As this issue has most stars of all, I'm now on the way to implement a cute editor
    for procedures and functions. It's nearly ready. Probably some user input before
    commiting would be nice. See attached screens.

     
  • Anonymous

    Anonymous - 2009-02-27

    Originally posted by: arjoc....@gmail.com

    I've just seen the screens. Good job.

     
  • Anonymous

    Anonymous - 2009-02-28

    Originally posted by: a...@anse.de

    Nearly done in [r2288] . Only the routines are not visible anywhere in Heidi so you can
    only create new routines.

     

    Related

    Commit: [r2288]

  • Anonymous

    Anonymous - 2009-03-02

    Originally posted by: arjoc....@gmail.com

    Thank you for including it on the build

     
  • Anonymous

    Anonymous - 2009-03-02

    Originally posted by: a...@anse.de

    Editing routines available in [r2293] - routines now get listed in the Database tab.

     

    Related

    Commit: [r2293]

  • Anonymous

    Anonymous - 2009-03-02

    Originally posted by: a...@anse.de

    Closing, looks ok now. Feel free to comment.

    Status: Fixed

     
MongoDB Logo MongoDB