SQL脚本

//声明

Declare p_tmpValue int DEFAULT null; 

Declare p_tmpName LONGTEXT DEFAULT ' ';

//IF IN SET

IF (p_tmpTag in ('A', 'B')) 

THEN

　　SET p_tmpValue=1;

END IF;

 

//增：

INSERT test.tags(ID, tmpTag, tmpValue)

VALUES(p_Id, p_tmpTag, p_tmpValue);

//删：

DELETE FROM test.Devices

WHERE DeviceId = p_DeviceId

AND p_TagName like '%,' || TagName || ',%'

//改：

UPDATE test.tags

SET DeviceName = p_DeviceName,

　　TagLength = p_TagLength

WHERE Id = p_Id;

//查：

SELECT DeviceSN, TagName

FROM test.devices

where TagId = p_Id