if _Email <> ''
then
update member set email = _Email where username=uname;
update account set email = _Email where username=uname;
end if; update account set password=_pwd, stly=_stly where username=uname;
参数
IN ‘uname‘ varchar(15),IN ‘_Email‘ varchar(32),IN ‘_pwd‘ varchar(32),IN ‘_stly‘ varchar(6)报错
1054-Unknown column '_Email' in 'field list'
then
update member set email = _Email where username=uname;
update account set email = _Email where username=uname;
end if; update account set password=_pwd, stly=_stly where username=uname;
参数
IN ‘uname‘ varchar(15),IN ‘_Email‘ varchar(32),IN ‘_pwd‘ varchar(32),IN ‘_stly‘ varchar(6)报错
1054-Unknown column '_Email' in 'field list'
BEGIN
if _Email <> ''
then
update member set email = _Email where username=uname;
update account set email = _Email where username=uname;
end if; update account set password=_pwd, stly=_stly where username=uname;
END
BEGIN
if _Email <> ''
then
update member set email = _Email where username=uname;
update account set email = _Email,password=_pwd, stly=_stly where username=uname;
else
update account set password=_pwd, stly=_stly where username=uname;
end if;END
CREATE PROCEDURE test1
(IN ‘uname‘ varchar(15),
IN ‘_Email‘ varchar(32),
IN ‘_pwd‘ varchar(32),
IN ‘_stly‘ varchar(6)
)
BEGIN
if _Email <> ''
then
update member set email = _Email where username=uname;
update account set email = _Email,password=_pwd, stly=_stly where username=uname;
else
update account set password=_pwd, stly=_stly where username=uname;
end if;END
‘->`
1054-Unknown column '_Email' in 'field list'
mysql>
mysql> CREATE PROCEDURE test1
-> (IN ‘uname‘ varchar(15),
-> IN ‘_Email‘ varchar(32),
-> IN ‘_pwd‘ varchar(32),
-> IN ‘_stly‘ varchar(6)
-> )
-> BEGIN
-> if _Email <> ''
-> then
-> update member set email = _Email where username=uname;
-> update account set email = _Email,password=_pwd, stly=_stly where
username=uname;
-> else
-> update account set password=_pwd, stly=_stly where username=uname
;
-> end if;
->
-> END
-> $$
Query OK, 0 rows affected (0.80 sec)mysql>问题说明越详细,回答也会越准确!参见如何提问。(提问的智慧)