Solved

How to Edit MySQL Routine

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

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

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…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

729 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