Home > other >  Sail soft statements calling mysql stored procedures didn't execute
Sail soft statements calling mysql stored procedures didn't execute

Time:09-19

A mysql 5. X with navicat build a stored procedure
The CREATE DEFINER=` root ` @ % ` ` PROCEDURE ` myproc ` (in ` project ` varchar (200))
The BEGIN
The DELETE FROM AList WHERE ProjectName=` project `;
Select * from AList WHERE ProjectName=` project `;
END

Call a stored procedure execution by sail soft statements,

Execution is successful, but the data is not deleted, after test, found the input parameter ` project ` remove ` ', become

The CREATE DEFINER=` root ` @ % ` ` PROCEDURE ` myproc ` (in project varchar (200))
The BEGIN
The DELETE FROM AList WHERE ProjectName=project;
Select * from AList WHERE ProjectName=project;
END

Sail soft statements the call is successful
  • Related