Solved

How to Edit MySQL Routine

Posted on 2012-04-11
6
148 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 35

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
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…
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…

733 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