1

I've created a lot of stored procedures when I was using HeidiSQL on Windows. I am now on an iMAC (x64) and it doesn't look like installing HeidiSQL is an option.

I've got MySQL Workbench version 8.0.24, it does list the stored procedures and functions but I cannot edit these in the application.

I'm surprised that this functionality appears to be missing or disabled. Has anyone got a suggestions? Tools that will work on iMAC (x64):

macOS Big Sur
Version 11.3.1
iMAC (Retina 5K, 27-inch, Late 2015)
Processor 4 GHz Quad-Core Intel Core i7
Memory 16 GB 1867 MHz DDR3
3
  • 1
    MySQL Workbench has long been ... underwhelming and messy. I use Sequel Pro and/or TablePlus when trying to get work done. Sequel Pro is free. TablePlus has a trial and is available for a fair price ... and works with multiple database engines.
    – matigo
    May 4 at 7:09
  • @matigo, Thank you downloading Sequel Pro will give it a go.
    – SPlatten
    May 4 at 7:28
  • @matigo, ok, downloaded and run, if I click a function or procedure, it creates a tab showing the name but that is all, there is no content displayed to edit.
    – SPlatten
    May 4 at 7:34
0

In workbench you find all to stored procedures, when you make a right cick on stored procedures.

In your case use Alter Stored procedures

It is basically all the same for view tables columns etc.

enter image description here

1
  • As a sidenote: these object editors (table editor, sp editor, trigger editor etc.) are designed to allow only the specific part of the language for which they are configured. This way you don't need any DELIMITER command in the code, nor can you write anything that doesn't match the current object type (it will all be reported as syntax errors). May 5 at 7:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.