mysql存储过程遍历删除语句报错帮忙看看

Question

语句

CREATE PROCEDURE delete_matches ( IN id INTEGER ) BEGIN
DELETE 
FROM
    lconstructionproject 
WHERE
    pid = id;

END　　

call delete_matches('1');

报错

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'call delete_matches('1')' at line 10

Answer 1

2个问题，END要加上分号，输入值是INTEGER所以不加 ' '
CREATE PROCEDURE delete_matches ( IN id INTEGER )
BEGIN
DELETE
FROM
lconstructionproject
WHERE
pid = id
END;　　

call delete_matches(1);