How to write a stored procedure in phpMyAdmin?

by

You can easily create procedures in phpMyAdmin.

  1. Go to your database. Click ‘Routines’ tab in header
  2. Click on ‘Add routine’

enter image description here

  1. Then a popup window will be opened. In that write your procedure and
    click on “GO”

For example like follows.
enter image description here

That’s it. You can view your created procedures under ‘Routines’ tab itself.

enter image description here

More Related Contents:

  1. How to write a stored procedure using phpmyadmin and how to use it through php?
  2. Store procedures 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. Checking the availability of rooms
  27. mysqli::query(): Couldn’t fetch mysqli
  28. Delete multiple rows by selecting checkboxes using PHP
  29. PDO::rowCount VS COUNT(*)
  30. How can I select rows in MySQL starting at a given row number?

Leave a Comment