qq_40969534的博客

SELECT ANY_VALUE ( a.PREV_CODE ) AS PREV_CODE, ANY_VALUE ( a.AD_CODE ) AS AD_CODE, ANY_VALUE ( a.ADMIN_ADNM ) AS ADMIN_ADNM, ANY_VALUE ( a.NATURAL_ADNM ) AS NATURAL_ADNM, ANY_VALUE ( a.PCHARGE_CODE ) AS PCHARGE_CODE, ANY_VALUE ( a.C...

CREATE DEFINER=`admin`@`%` PROCEDURE `pro_inspection`(IN inspectionCode varchar(50),IN hystCode varchar(50),IN status varchar(25),IN start datetime,IN end datetime)BEGINSELECT a.INSPECTION_CODE, d.HYST_CODE, d.HYST_NAME, CONCAT(e....

select VIEW_DEFINITION from information_schema.views where TABLE_SCHEMA='database' and TABLE_NAME='view'

CREATE DEFINER=`admin`@`%` PROCEDURE `pro_monitor_item_count`(IN projectCode varchar(25))BEGIN #Routine body goes here...select `a`.`NAME` AS `NAME`,`a`.`CODE` AS `CODE`,if(isnull(`c`.`count`),0,`c`.`count`) AS `COUNT` from (`jh_monitor_inst_manage`...

SELECT*FROM `project_stage` `b`WHERE ( NOT ( EXISTS ( SELECT 1 FROM `project_stage` `a` WHERE (( `b`.`Project_Code...

select DATE_SUB(now(),interval '1' DAY_SECOND)

update ds_user_role_relation a join system_userinfo b on (a.USER_CODE=b.USER_CODE) set a.ad_code =b.ADMIN_DIV_CODE;

SELECT CAST(CAST(SYSDATE()AS DATE)AS DATETIME)

SELECT `hbi`.`HYST_CODE` AS `HYST_CODE`, `ad2`.`AD_CODE` AS `CITY_CODE`, `ad2`.`AD_NAME` AS `CITY_NAME`, `ad1`.`AD_CODE` AS `COUNTY_CODE`, `ad1`.`AD_NAME` AS `COUNTY_NAME`,( CASE `ad`.`AD_LEV` WHEN 3 THEN...

SELECT group_concat(AD_NAME SEPARATOR '、') FROM `ad_base_infos` where AD_LEV=1group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])