下面这个存储过程不知道错在哪里 请指点DELIMITER $$DROP PROCEDURE IF EXISTS `datumdm`.`SP_Text_Delete` $$
CREATE PROCEDURE `datumdm`.`SP_Text_Delete`
(
in _id INT
)START TRANSACTION;UPDATE `Text` SET Deleted = b'1' WHERE ID = _id;
UPDATE `Media` SET Deleted = b'1' WHERE TextID = _id AND Deleted = b'0';
COMMIT;DELIMITER ;
DELIMITER $$DROP PROCEDURE IF EXISTS `datumdm`.`SP_Text_Delete` $$
CREATE PROCEDURE `datumdm`.`SP_Text_Delete`
(
in _id INT
)
begin
START TRANSACTION;UPDATE `Text` SET Deleted = binary(1) WHERE ID = _id;
UPDATE `Media` SET Deleted = binary(1) WHERE TextID = _id AND Deleted = binary(0);
COMMIT;
end$$DELIMITER ;