-- 传入女神名,返回女神名 and 男神名
DELIMITER $
CREATE PROCEDURE task8(IN bname VARCHAR(20),OUT str VARCHAR(50))
BEGIN
SELECT concat(bname,'and',ifnull(bo.boyname,'null')) INTO str
FROM boys bo
RIGHT JOIN beauty b
ON b.boyfiend_id=bo.id
WHERE b.name=bname;
END $
CALL task8('苍老师',@s)
为啥我执行
CALL task8('苍老师',@s)代码的时候会报
错误代码: 1054
Unknown column 'b.boyfiend_id' in 'on clause'
这个错误呢
'b.boyfiend_id'是.boyfriend,英文打错了