该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
求助 Mysql 存储过程 更新表问题
DELIMITER $$
DROP PROCEDURE IF EXISTS `erp`.`Erp_ModifyUser` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Erp_ModifyUser`(
in Ts_Uid bigint,
in TS_Name varchar(50),
in TS_Dep_ID bigint,
in TS_Email varchar(50),
in TS_NPhone varchar(10),
in TS_Phone varchar(20),
in TS_MPhone varchar(20),
in TS_Duty varchar(50),
in TS_Birthday varchar(50),
in TS_Visage_ID bigint,
in TS_Cre varchar(20),
in TS_Stat int,
in TS_IsAP int,
in TS_BZ varchar(8000),
in TS_Sex int
)
BEGIN
set @Ts_Uid=Ts_Uid;
set @TS_Name =TS_Name;
set @TS_Dep_ID =TS_Dep_ID;
set @TS_Email =TS_Email;
set @TS_NPhone =TS_NPhone;
set @TS_Phone =TS_Phone;
set @TS_MPhone =TS_MPhone;
set @TS_Duty =TS_Duty;
set @TS_Birthday =TS_Birthday;
set @TS_Visage_ID =TS_Visage_ID;
set @TS_Cre =TS_Cre;
set @TS_Stat =TS_Stat;
set @TS_IsAP =TS_IsAP;
set @TS_BZ =TS_BZ;
set @TS_Sex = TS_Sex;
update TS_UserInf set TS_Name=@TS_Name,TS_Dep_ID=@TS_Dep_ID,TS_Email=@TS_Email,TS_NPhone=@TS_NPhone,TS_Phone=@TS_Phone
,TS_MPhone=@TS_MPhone,TS_Duty=@TS_Duty,TS_Birthday=@TS_Birthday,
TS_Visage_ID=@TS_Visage_ID,TS_Stat=@TS_Stat,TS_IsAP=@TS_IsAP,TS_BZ=@TS_BZ,
TS_Cre=@TS_Cre,TS_Sex=@TS_Sex where Ts_Uid=@Ts_Uid;
END $$
DELIMITER ;
每个参数的值 都对 但是没次更新的时候 表中所有数据都更新 就和没有where一样