Mysql基础存储过程
#查询表 user
select * from user
#删除seleUser()存储过程
drop procedure if exists seleUser;
**#查询所有**
create procedure seleUser()
begin
select * from `user`;
end;;
call seleUser();
#删除seleUserId()
drop procedure if exists seleUserId;
**#根据id查询**
create procedure seleUserId(in id INTEGER)
begin
select * from `user` where uid = id;
end;;
call seleUserId(1);
drop procedure if exists login;
**#判断是否存在 返回count(*)**
create procedure login(in NewAccount varchar(50),in NewPwd varchar(50))
begin
select count(*) from `user` where account = NewAccount and pwd = NewPwd;
end;;
call login('404','123');
#删除addUser()存储过程
drop procedure if exists addUser;
**#新增**
create procedure addUser(in NewUname varchar(50),in NewAccount varchar(50),in NewPwd varchar(50),in NewSex char(2))
begin
insert into user(uname,account,pwd,sex)value(NewUname,NewAccount,NewPwd,NewSex);
end;;
call addUser('王五','wangW','111','女');
drop procedure if exists deleIdUser;
**#根据id删除**
create procedure deleIdUser(in NewUid INTEGER)
begin
DELETE from user where uid = NewUid;
end;;
call deleIdUser(2);
drop procedure if exists uptIdUser;
**#根据id修改**
create procedure uptIdUser(in NewUid int,in NewUname varchar(50),in NewAccount varchar(50),in NewPwd varchar(50),in NewSex char(2))
begin
UPDATE user set uname=NewUname,account=NewAccount,pwd=NewPwd,sex=NewSex where uid = NewUid;
end;;
call uptIdUser(3,'小花','Xhua','123456','女');
**
不喜勿喷 谢谢大家了
**