Solved

How to Edit MySQL Routine

Posted on 2012-04-11
6
147 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
parse url to form? 7 25
Ouput in html in powershell 2 20
Giant ibd file for our biggest table on mysql 2 18
Fix Form size HTML 16 15
Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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.

831 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