Store procedures in phpMyAdmin

by

There is a way, see this link: http://blog.nth-design.com/2009/02/25/creating-sp-in-phpmyadmin/

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: 

DROP PROCEDURE IF EXISTS spFoo $$
CREATE PROCEDURE spFoo ()
BEGIN
    SELECT 'Foo' FROM DUAL;
END $$

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

More Related Contents:

  1. How to write a stored procedure using phpmyadmin and how to use it through php?
  2. How to write a stored procedure in phpMyAdmin?
  3. Can I store query result of one field into different variables? if not then what should I do for that?
  4. The requested URL was not found on this server.
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. How to call a MySQL stored procedure from within PHP code?
  7. Import file size limit in PHPMyAdmin
  8. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  9. Mysql event error using php
  10. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  11. Calling stored procedure with Out parameter using PDO
  12. How to solve time out in phpmyadmin?
  13. WAMP/MySQL errors not in correct language
  14. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  15. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  16. phpmyadmin automatic logout time
  17. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Extension mysqli is missing, phpmyadmin doesn’t work
  20. How to SELECT DEFAULT value of a field
  21. Stored Procedures, MySQL and PHP
  22. How to log in to phpMyAdmin with WAMP, what is the username and password?
  23. Auto Increment skipping numbers?
  24. Installing PDO driver on MySQL Linux server
  25. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  26. Fatal error: Call to undefined function mysql_connect()
  27. How can I properly use a PDO object for a parameterized SELECT query
  28. Doctrine Query Language get Max/Latest Row Per Group
  29. Getting a PHP PDO connection from a mysql_connect()?
  30. Escaping SQL queries in Codeigniter

Leave a Comment