这节课里面的例子,我自己敲怎么总有语法错误,求大神围观指导。
DELIMITER $$
CREATE PROCEDURE kk(IN k_id SMALLINT UNSIGNED,OUT sum SMALLINT UNSIGNED,OUT left SMALLINT UNSIGNED)
BEGIN
DELETE FROM pd_test WHERE k_id=id;
SELECT ROW_COUNT() INTO sum;
SELECT COUNT(id) FROM pd_test INTO left;
END
$$
创建存储过程kk,,已有表pd_test, 里面有属性id,对了几遍跟视频里面一样,而且begin跟end中的SQL语言拿去单独执行都成功,连在一起就不行。。。求指导