SQL语句修改及更新模块

SELECT * FROM BAS_VERSION WHERE ENT_CODE='20510001' OR ENT_CODE='20710001' AND  IS_VALID='1'

UPDATE BAS_VERSION SET IS_VALID='0' WHERE ENT_CODE='20710001' AND IS_VALID='1'  AND CLIENT_TYPE = '2' ;
UPDATE BAS_VERSION SET IS_VALID='0' WHERE ENT_CODE='20510002' AND IS_VALID='1'  AND CLIENT_TYPE = '2' ;


INSERT INTO DBREAD.BAS_VERSION
(ENT_CODE, VERSION, CLIENT_TYPE, UPDATE_URL, UPDATE_COMMENT, IS_VALID, UPDATE_TIME)
VALUES('20510002', '1.201707063A', '2', 'itms-services://?action=download-manifest&url=https://git.oschina.net/heichong/ctitc/raw/master/terminal-sichuan-test.plist', 'IOS-四川测试版本-价格与库存功能调整', '1', CURRENT_TIMESTAMP);

INSERT INTO DBREAD.BAS_VERSION
(ENT_CODE, VERSION, CLIENT_TYPE, UPDATE_URL, UPDATE_COMMENT, IS_VALID, UPDATE_TIME)
VALUES('20710001', '1.201707063A', '2', 'itms-services://?action=download-manifest&url=https://git.oschina.net/heichong/ctitc/raw/master/terminal-sichuan-test.plist', 'IOS-四川测试版本-价格与库存功能调整', '1', CURRENT_TIMESTAMP);