WebFaction
Community site: login faq
1
1

I need to add/edit stored procedures in my MySQL database. Is it possible to add/edit using the control panel or phpAdmin? Or do I have to keep executing ALTER PROCEDURE statements to perform the edits?

Thanks, Barry

asked 24 Nov '10, 13:16

barrettlee
26126
accept rate: 0%

edited 24 Nov '10, 13:17


We do not permit stored procedures in the shared MySQL. If you need to use stored procedures, you will need to install your own version of MySQL in your home directory.

permanent link

answered 24 Nov '10, 13:22

maryh
1.3k7
accept rate: 35%

1

Oh. Thats rather disappointing. (Sounds like something that godaddy would do). What is the rationale behind that?

(24 Nov '10, 13:34) barrettlee

We've seen very marginal demand for stored procedures. If demand grows then we'll consider supporting them.

(25 Nov '10, 04:11) remi

I have installed MySQL in my home directory. I guess its nice not to have to name my databases with my user name and I am running on my own process. It will allow me to change other settings too. Very good to able to build what I need.

Thanks,
Barry

permanent link

answered 04 Dec '10, 16:58

barrettlee
26126
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×168
×84
×1

question asked: 24 Nov '10, 13:16

question was seen: 3,520 times

last updated: 04 Dec '10, 16:58

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM