create procedure login(in name varchar(10),pwd varchar(10)) begin select * from tableLogin where username=name and password=pwd end;为什么总是不行呢?
不好意思,在 pwd 前少了个 increate procedure login(in name varchar(10),in pwd varchar(10)) begin select * from tableLogin where username=name and password=pwd end;
你试下 create procedure login (_name varchar(10), _pwd varchar(10)) begin select * from tableLogin where username=_name and password=_pwd; end;
Thanks zhouxin82 !还是不行呀?
delimiter $$ create procedure login( name varchar(10),in pwd varchar(10)) begin select * from tableLogin where username=name and password=pwd; end$$ delimiter ;
这个是对的 select * from tableLogin where username=name and password=pwd; 后面的;把存储过程截断了
begin
select * from tableLogin where username=name and password=pwd
end;为什么总是不行呢?
begin
select * from tableLogin where username=name and password=pwd
end;
create procedure login
(_name varchar(10),
_pwd varchar(10))
begin
select * from tableLogin where username=_name and password=_pwd;
end;
create procedure login( name varchar(10),in pwd varchar(10))
begin
select * from tableLogin where username=name and password=pwd;
end$$
delimiter ;
这个是对的
select * from tableLogin where username=name and password=pwd;
后面的;把存储过程截断了