Solved

How to Edit MySQL Routine

Posted on 2012-04-11
6
140 Views
Last Modified: 2012-07-07
I have a MySQL Routine that i want to edit.
When I click on 'View with all text' i can see the paragraph Routine_Definition with the actual instructions, but only in printer ready display.  If i click the SQL button it shows me only a generic select statement.  Not the real instructions of the procedure. How are you supposed to edit?
0
Comment
Question by:GarySB
  • 3
6 Comments
 
LVL 34

Expert Comment

by:gr8gonzo
ID: 37837055
What program are you using?
0
 

Author Comment

by:GarySB
ID: 37838152
I go to my CPanel that has a MyPHPMyAdmin cPanel version 11.32 that opens up the database and I then click on Information_Schema.  In that list it has Routines.  In Routines are several  procedures with routine_definition that start Begin Select from etc.
I need to change the Where clause.  I do not care if this is accomplished by editing the existing one or creating a new one, delete the old and rename to the original or if an Experts-Exchange MySQL coder wants to see the actual code through Team Viewer to modify it (I will of course pay for this).  The update must replace the existing routine.
Let me know how this can be done and if  you  can modify a sql routine.
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 37838665
You will need to drop/create the routine to change it.  Get the current text of the routine, then drop it.  Edit the text, and create it using the new text.
0
 

Accepted Solution

by:
GarySB earned 0 total points
ID: 38145621
I have my database and Information Schema as  a drop down selection where my routines are.  For some reason the program will  not allow you to edit if you try to modify a routine when you have the Information Schema selected.  It must be on the main database selection to edit an existing routine.  Another programmer i used to work with told me and it worked.
0
 

Author Closing Comment

by:GarySB
ID: 38162421
This solution worked and no need to go any further.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this tutorial viewers will learn how to embed an audio file in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: : The declaration should display (CODE) HTML5 is supported by the most recent versions of all major browsers…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now