• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

How to Edit MySQL Routine

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
GarySB
Asked:
GarySB
  • 3
1 Solution
 
gr8gonzoConsultantCommented:
What program are you using?
0
 
GarySBAuthor Commented:
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
 
Steve BinkCommented:
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
 
GarySBAuthor Commented:
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
 
GarySBAuthor Commented:
This solution worked and no need to go any further.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now