How to write SP in phpMyAdmin (MySQL)?

How to write a stored procedure in phpMyAdmin?

+3
source share
2 answers

In phpMyAdmin, you can create a stored procedure in an SQL window.

You may need to set the delimiter to something like "$$" instead of the default ";". You can change this at the bottom of the SQL window.

Stored Procedure in phpMyAdmin

+5
source

Copied from the internet:

Answer: yes and no. PhpMyAdmin does not have tools for creating stored procedures, but you can enter SQL using it and thereby creating them.

(Note. I do not believe that previous versions of MySQL 5 supported procedures.)

+1
source

Source: https://habr.com/ru/post/1309891/


All Articles