原来的存储过程是这样写的
DELIMITER $$DROP FUNCTION IF EXISTS `UpdateUser` $$
CREATE DEFINER=`exadmin`@`localhost` FUNCTION `UpdateUser`(
v_ID INT(16),
v_Login VARCHAR(767),
v_FirstName VARCHAR(2000),
v_LastName VARCHAR(2000),
v_ContactInfo VARCHAR(2000),
v_AuthorityLevel VARCHAR(2000),
v_CompanyName VARCHAR(767),
v_Enabled TINYINT(1)) RETURNS int(10)
BEGIN
DECLARE isLoginExist INT(2);
DECLARE isCompanyExist INT(2);
DECLARE v_CompanyID INT(16);
DECLARE v_AutorityID INT(16);
DECLARE v_Enabled INT(16);
SELECT COUNT(1) INTO isLoginExist
FROM `ETI_CUST`.`users`
WHERE ID != v_ID AND LOGIN = v_Login;
IF isLoginExist > 0 THEN RETURN -1;
END IF; BEGIN
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
RETURN -2;
END;
SELECT `ID` INTO v_CompanyID
FROM `ETI_CUST`.`company`
WHERE CORP_NAME = v_CompanyName;
END; BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN RETURN -3;
END; SELECT `ID` INTO v_AutorityID
FROM `ETI_CUST`.`autority`
WHERE `LEVEL` = v_AuthorityLevel; SELECT `ID` INTO v_Enabled
FROM `ETI_CUST`.`company`
WHERE `ENABLED` = v_AuthorityLevel; UPDATE `ETI_CUST`.`users`
SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled
WHERE ID = v_ID;
END; RETURN 0;
END $$DELIMITER ;现在我想往里面加两个字段就是 V_CellNumber VARCHAR(2000),
V_Address VARCHAR(2000),在update表的时候用到了。SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled,CELL_NUMBER=V_CellNumber,ADDRESS=V_Address如下:DELIMITER $$DROP FUNCTION IF EXISTS `UpdateUser` $$
CREATE DEFINER=`exadmin`@`localhost` FUNCTION `UpdateUser`(
v_ID INT(16),
v_Login VARCHAR(767),
v_FirstName VARCHAR(2000),
v_LastName VARCHAR(2000),
v_ContactInfo VARCHAR(2000),
v_AuthorityLevel VARCHAR(2000),
v_CompanyName VARCHAR(767),
v_Enabled TINYINT(1),
V_CellNumber VARCHAR(2000),
V_Address VARCHAR(2000)) RETURNS int(10)
BEGIN
DECLARE isLoginExist INT(2);
DECLARE isCompanyExist INT(2);
DECLARE v_CompanyID INT(16);
DECLARE v_AutorityID INT(16);
DECLARE v_Enabled INT(16);
SELECT COUNT(1) INTO isLoginExist
FROM `ETI_CUST`.`users`
WHERE ID != v_ID AND LOGIN = v_Login;
IF isLoginExist > 0 THEN RETURN -1;
END IF; BEGIN
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
RETURN -2;
END;
SELECT `ID` INTO v_CompanyID
FROM `ETI_CUST`.`company`
WHERE CORP_NAME = v_CompanyName;
END; BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN RETURN -3;
END; SELECT `ID` INTO v_AutorityID
FROM `ETI_CUST`.`autority`
WHERE `LEVEL` = v_AuthorityLevel; SELECT `ID` INTO v_Enabled
FROM `ETI_CUST`.`company`
WHERE `ENABLED` = v_AuthorityLevel; UPDATE `ETI_CUST`.`users`
SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled,CELL_NUMBER=V_CellNumber,ADDRESS=V_Address
WHERE ID = v_ID;
END; RETURN 0;
END $$
请问为什么我改这两个数据数据库里的数据为什么没改掉??谢谢大侠们。DELIMITER ;
DELIMITER $$DROP FUNCTION IF EXISTS `UpdateUser` $$
CREATE DEFINER=`exadmin`@`localhost` FUNCTION `UpdateUser`(
v_ID INT(16),
v_Login VARCHAR(767),
v_FirstName VARCHAR(2000),
v_LastName VARCHAR(2000),
v_ContactInfo VARCHAR(2000),
v_AuthorityLevel VARCHAR(2000),
v_CompanyName VARCHAR(767),
v_Enabled TINYINT(1)) RETURNS int(10)
BEGIN
DECLARE isLoginExist INT(2);
DECLARE isCompanyExist INT(2);
DECLARE v_CompanyID INT(16);
DECLARE v_AutorityID INT(16);
DECLARE v_Enabled INT(16);
SELECT COUNT(1) INTO isLoginExist
FROM `ETI_CUST`.`users`
WHERE ID != v_ID AND LOGIN = v_Login;
IF isLoginExist > 0 THEN RETURN -1;
END IF; BEGIN
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
RETURN -2;
END;
SELECT `ID` INTO v_CompanyID
FROM `ETI_CUST`.`company`
WHERE CORP_NAME = v_CompanyName;
END; BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN RETURN -3;
END; SELECT `ID` INTO v_AutorityID
FROM `ETI_CUST`.`autority`
WHERE `LEVEL` = v_AuthorityLevel; SELECT `ID` INTO v_Enabled
FROM `ETI_CUST`.`company`
WHERE `ENABLED` = v_AuthorityLevel; UPDATE `ETI_CUST`.`users`
SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled
WHERE ID = v_ID;
END; RETURN 0;
END $$DELIMITER ;现在我想往里面加两个字段就是 V_CellNumber VARCHAR(2000),
V_Address VARCHAR(2000),在update表的时候用到了。SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled,CELL_NUMBER=V_CellNumber,ADDRESS=V_Address如下:DELIMITER $$DROP FUNCTION IF EXISTS `UpdateUser` $$
CREATE DEFINER=`exadmin`@`localhost` FUNCTION `UpdateUser`(
v_ID INT(16),
v_Login VARCHAR(767),
v_FirstName VARCHAR(2000),
v_LastName VARCHAR(2000),
v_ContactInfo VARCHAR(2000),
v_AuthorityLevel VARCHAR(2000),
v_CompanyName VARCHAR(767),
v_Enabled TINYINT(1),
V_CellNumber VARCHAR(2000),
V_Address VARCHAR(2000)) RETURNS int(10)
BEGIN
DECLARE isLoginExist INT(2);
DECLARE isCompanyExist INT(2);
DECLARE v_CompanyID INT(16);
DECLARE v_AutorityID INT(16);
DECLARE v_Enabled INT(16);
SELECT COUNT(1) INTO isLoginExist
FROM `ETI_CUST`.`users`
WHERE ID != v_ID AND LOGIN = v_Login;
IF isLoginExist > 0 THEN RETURN -1;
END IF; BEGIN
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
RETURN -2;
END;
SELECT `ID` INTO v_CompanyID
FROM `ETI_CUST`.`company`
WHERE CORP_NAME = v_CompanyName;
END; BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN RETURN -3;
END; SELECT `ID` INTO v_AutorityID
FROM `ETI_CUST`.`autority`
WHERE `LEVEL` = v_AuthorityLevel; SELECT `ID` INTO v_Enabled
FROM `ETI_CUST`.`company`
WHERE `ENABLED` = v_AuthorityLevel; UPDATE `ETI_CUST`.`users`
SET `LOGIN` = v_Login, FIRST_NAME = v_FirstName, LAST_NAME = v_LastName, CONTACT_INFO = v_ContactInfo, COMPANY_ID = v_CompanyID, ENABLED = v_Enabled,CELL_NUMBER=V_CellNumber,ADDRESS=V_Address
WHERE ID = v_ID;
END; RETURN 0;
END $$
请问为什么我改这两个数据数据库里的数据为什么没改掉??谢谢大侠们。DELIMITER ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货