Para criar um Procedure no phpMyadmin, primeiro você deverá acessar o **phpMyadmin** através do cPanel.

![](https://support2.scriptcase.net/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbmhRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c1e4bcaa0b92f26ce3bedb195853655118433b2d/Screenshot%20(1).png)

1. Clique no seu banco de dados que fica localizado no lado esquerdo, após isso, clique em "**Rotinas**";


![](https://support2.scriptcase.net/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbmxRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--4f1314b2803b079dfea3b0502484c989f1f2e902/Screenshot%20_1\_.png)

1. E seguida clique em "**Adicionar** **Rotina**";


![](https://support2.scriptcase.net/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbnBRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1a5a68e2c0f8db9550b58be2708aa376f275add9/Screenshot%20_2\_.png)

1. Preencha com os dados e parâmetros e clique em  "**Executar**";


![](https://support2.scriptcase.net/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbnRRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--4eb9197447c203a0ebfd071d407d21f8ab5c86fe/Screenshot%20_5\_.png)

4.  Após isso, será exibido a Procedure criada, conforme a imagem a seguir:

​

```
```

![](https://support2.scriptcase.net/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbnhRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--a63d703b9069fc96097d340e72546a17a2e25a09/Screenshot%20(2).png)


```

Espero ter ajudado !
```