wushuo30的专栏

INSERT INTO HSKSZSHD ( ORDNO, TOROKUYMDHMS) VALUES ('3',cast ('2013-07-09 15:52:19' AS TIMESTAMP))

1.SELECT* FROM PMS_PRODUCT_INFO X WHERE NOT exists (      select *      from PMS_PRODUCT_INFO Y      WHERE Y.PRODUCT_ID=X.PRODUCT_ID AND Y.LANG_ID=X.LANG_ID AND Y.OS_ID=X.OS_ID AND (

with partents as(select * from b_sys_org_adm where ORG_CODE ='ADM_100010301013'UNION ALL (SELECT a.* from b_sys_org_adm as a inner join  partents as b on a.ORG_CODE=b.ORG_PCODE ))SELEC

CREATE DEFINER=`root`@`%` FUNCTION `FIND_SET_IN_SET`(targetStr varchar(2000),findStr varchar(2000)) RETURNS int(11) READS SQL DATABEGINDECLARE strNum int;DECLARE lenIndex int DEFAULT 1;DECLARE...