Home > Database > Mysql Tutorial > How Can I Create Stored Procedures in phpMyAdmin Without a Delimiter Change Option?

How Can I Create Stored Procedures in phpMyAdmin Without a Delimiter Change Option?

Patricia Arquette
Release: 2024-10-31 21:49:02
Original
341 people have browsed it

How Can I Create Stored Procedures in phpMyAdmin Without a Delimiter Change Option?

Creating Stored Procedures with phpMyAdmin

When adding stored procedures to a MySQL database managed with phpMyAdmin, users may encounter limitations due to the lack of a delimiter change option. To bypass this, here's an alternative method that involves manually setting the delimiter:

  1. Locate the SQL tab within phpMyAdmin.
  2. Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements!
  3. Below the SQL editor's text area, specify $$ as your delimiter in the delimiter field.
  4. Execute the SQL statements, which will create the stored procedures as intended.

For a detailed example, refer to the provided link: http://blog.nth-design.com/2009/02/25/creating-sp-in-phpmyadmin/

The above is the detailed content of How Can I Create Stored Procedures in phpMyAdmin Without a Delimiter Change Option?. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template