PHP和MySQL中的过程问题

Question

When I run my program for the first time, I would like to create the following procedure:

$returnCusProcedure = "
    DELIMITER //
    CREATE PROCEDURE GetAllCustomers()
    BEGIN
    SELECT * FROM CUSTOMERS;
    END //
    DELIMITER ; ";

if(! $returnCusProcedure )
{
    die('Could not create procedure: ' . $conn->error);
}
else
{
    echo "Procedure created successfully<br/>";
}

It echos out that the procedure has completed successfully but when I call that procedure in MySQL, it returns that the procedure does not exist, am I missing something from above?

Answer 1

You have to actually execute those SQL statements. It would be something like:

$cusProcedure = "
    CREATE PROCEDURE GetAllCustomers()
    BEGIN
    SELECT * FROM CUSTOMERS;
    END"; // <-- No need to change delimiter, at least in this case

$returnCusProcedure = $conn->query($cusProcedure); // <-- Executing SQL

if(! $returnCusProcedure )
{
    die('Could not create procedure: ' . $conn->error);
}
else
{
    echo "Procedure created successfully<br/>";
}