Question

mysql创建存储过程失败！

CREATE PROCEDURE indexdphp(OUT changed BOOLEAN)
BEGIN
SELECT COUNT( * ) into changed
FROM `pdo_test`.`cache_tables`
IN (
'visitlog'
)
LIMIT 1;
END
加上
WHERE `tname`
还是不行

Answer 1

SELECT COUNT( * ) into changed
FROM `pdo_test`.`cache_tables`
IN (
'visitlog'
)
语法错误。。 cache_tables 后面跟上 where 字段名 in('visitlog')

Answer 2

OUT changed BOOLEAN 数据类型不对吧！