Are MySQL stored procedures allowed?


#1

I would like to create some MySQL stored procedures if that is possible. Therefore, 2 questions

  1. Are we allowed to create MySQL stored procedures in our MySQL databases? (I found some very old posts from 2009/2010 that say it was not allowed then but I’m wondering if that policy has changed since then.)

  2. Where can I create the stored procedures? For instance, can I create them at the SQL tab in myPHPAdmin or is there some other place I can create them?


#2

Hi @RhinoSFL!

Are we allowed to create MySQL stored procedures in our MySQL databases?

According to privileges setup, yes you can :slight_smile:

Where can I create the stored procedures?

Through phpMyAdmin. Select your database, click on Routines tab and create a new procedure :wink:


#3

That’s great news. Just one problem: where is the Routines tab? I can’t find this in my copy of phpMyAdmin. Am I running an older version? If so, how do I upgrade it to a version that has a Routines tab?


#4

Just one problem: where is the Routines tab?

The navbar tabs from top, right side.

I can’t find this in my copy of phpMyAdmin.

I don’t know… Use the latest version of phpMyAdmin :slight_smile:


#5

According to a post from late 2017, we (customers) can’t update to newer versions of phpMyAdmin. Admins presumably can update phpMyAdmin but apparently don’t do it on request. Is that correct?


#6
  1. First select your database from left:

2

  1. Then hit on Routines


#7

Did you upgrade my version of phpMyAdmin? Because I absolutely, positively, did NOT upgrade it and I did not have a Routines tab either. But now I do.

So thank you if you did that.


#8

Did you upgrade my version of phpMyAdmin? Because I absolutely, positively, did NOT upgrade it and I did not have a Routines tab either. But now I do.

It was no update. You simply need to select the database to which you want to add the routines.

We’re glad the issue has been solved :blush: