Are MySQL stored procedures allowed?

Community support
#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?