CREATE PROCEDURE `sptest`() BEGIN DECLARE id1 int(11)NOT NULL; SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105'; SELECT * FROM contractinfo WHERE ContractID=@id1; END;
CREATE PROCEDURE `sptest`() BEGIN DECLARE id1 int(11) NOT NULL; SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105'; SELECT * FROM contractinfo WHERE ContractID=id1; END;
CREATE PROCEDURE `sptest`() BEGIN DECLARE id1 int(11); --not null不能定义 SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105'; SELECT * FROM contractinfo WHERE ContractID=id1; END;
mysql中变量声明不能带‘@’符号吗??
CREATE PROCEDURE `sptest`() BEGIN DECLARE id1 int(11)NOT NULL; SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105'; SELECT * FROM contractinfo WHERE ContractID=id1; END;
BEGIN
DECLARE id1 int(11)NOT NULL;
SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105';
SELECT * FROM contractinfo WHERE ContractID=@id1;
END;
CREATE PROCEDURE `sptest`()
BEGIN
DECLARE id1 int(11) NOT NULL;
SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105';
SELECT * FROM contractinfo WHERE ContractID=id1;
END;
CREATE PROCEDURE `sptest`()
BEGIN
DECLARE id1 int(11); --not null不能定义
SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105';
SELECT * FROM contractinfo WHERE ContractID=id1;
END;
BEGIN
DECLARE id1 int(11)NOT NULL;
SELECT ContractID into id1 FROM contractinfo WHERE SymbolNum='al1105';
SELECT * FROM contractinfo WHERE ContractID=id1;
END;