store procedures in phpmyadmin

store procedures in phpmyadmin  using -'php,mysql,stored-procedures,phpmyadmin'

I must add stored procedures to MySQL database.

The problem is that the hosting offers phpMyAdmin to manage the database.

I searched on the Internet and the idea is to run the MySQL native statement that creates the procedures, but as the code of procedures often may have ;, we have to change the delimiter in MySQL.

phpMyAdmin does not have this option. Has anyone tried to create stored procedures manually setting the anchor, or something that worked?

asked Oct 13, 2015 by patelnikul321
0 votes

4 Answers

0 votes

There is a way, see this link:

Quote from that link
1.Open phpMyadmin.
2.Select a database to work with.
3.Open the SQL tab.
4.Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements! Here’s what my example script should look like:

END $$

5.In the delimiter field, just below the SQL editor’s text area, enter $$ as your delimiter.

answered Oct 13, 2015 by abhimca2006
0 votes

Why everybody tries to use a visual tool as console?!? There is an easyer way:

Go to your database, and look for "More"

enter image description here

Then this screen will show. If you have created any stored procedures, they will be listed

enter image description here

To add new one click "Add routine"

enter image description here

answered Oct 13, 2015 by yogeshplv
0 votes

You can set a delimiter manually using delimiter $$, where $$ is your chosen delimiter. This works on my shared hosting with phpMyAdmin. You should remember to set it back to ; when you are finished.

answered Oct 13, 2015 by girisha
0 votes

Try to create/edit stored procedures and other MySQL objects with visual object editors in dbForge Studio for MySQL. The express edition is free.

  1. Connectivity question - what to do if there is no direct connection to MySQL server? Possible ways: HTTP tunneling - may be used to connect to the MySQL server, it is a method of connecting to the server through HTTP/HTTPS protocol, or using secure connection (SSH/SSL network protocol).
  2. The DELIMITER client command is supported by suggested tool. So, this command can be used in the scripts. Also, stored procedures and other objects may be created and modified in visual editors.
answered Oct 13, 2015 by tseetha