delimiter $$
CREATE PROCEDURE `bools`(in ming varchar(20) , in ada varchar(20))
BEGIN DECLARE u VARCHAR(20); SELECT book.bkISBN INTO @u FROM book WHERE book.bkName=ming;
UPDATE book SET bkName=ada WHERE professbook.pbkISBN=@u;
END$$
delimiter ;
CREATE PROCEDURE `bools`(in ming varchar(20) , in ada varchar(20))
BEGIN DECLARE u VARCHAR(20); SELECT book.bkISBN INTO @u FROM book WHERE book.bkName=ming;
UPDATE book SET bkName=ada WHERE professbook.pbkISBN=@u;
END$$
delimiter ;
比如说我要输入(算法设计,art)
然后运行提示Procedure execution failed
1054 - Unknown column '算法设计' in 'field list'可是我book.bkName里确实有'算法设计'这个数据啊
在MYSQL中运行,是否有结果call bools('算法设计',art)
你的字符串常量有没有加 引号?('算法设计',art)
其中WHERE professbook.pbkISBN=@u; 有问题吧, 你条件想是:WHERE book.bkISBN=@u;?????
create define='root'@'localhost' procedure 'bools'(in ming varchar(20)
in data varchar(20))O
begin
declare u varchar(20)
select book.bklsbn into@u from book where book.bkname=ming;
update book set bkname=ada where proessbook.pbkisbn=@u;end$$
delimiter;