这个存储过程怎么错了

Question

我想删除作为参数发送到此过程的与userID相关的所有内容。

CREATE PROCEDURE `deleteUser`(userid INT)
BEGIN
DECLARE v_userid INT;
SET v_userid = userid;
DELETE * FROM Reply where user_id = v_userid;
DELETE * FROM Post where user_id = v_userid;
DELETE FROM Users where user_id = v_userid;
END

Answer 1

您可能缺少DELIMITER

它应该看起来像

DELIMITER //
CREATE PROCEDURE `deleteUser`(userid INT)
BEGIN
DECLARE v_userid INT;
SET v_userid = userid;
DELETE * FROM Reply where user_id = v_userid;
DELETE * FROM Post where user_id = v_userid;
DELETE FROM Users where user_id = v_userid;
END //