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