mysql为视图添加主键_视图中添加主键的方法

CREATE OR REPLACE VIEW T_GDXM(

GD_GUID,

ZD_GUID,

XZQ_DM

,XM_GUID

,XM_ZT

,XM_XH

,BH

,DZ_BA_BH

,XM_MC

,TZZT_XZ

,HY_FL

,TD_JB

,ZD_BH

,TD_ZL

,GD_ZMJ

,GY_FS

,GY_MJ

,XZ_MJ

,TD_YT

,CR_NX

,YT_SM

,JD_SJ

,JE

,GDZC_TZE

,TZ_QD

,ZT_JZ_XZ

,FS_JZ_XZ

,JZ_MJ

,MIN_JZ_MD

,MAX_JZ_MD

,MIN_RJL

,MAX_RJL

,MIN_LHL

,MAX_LHL

,MIN_JZ_GD

,MAX_JZ_GD

,QT_TD_YQ

,DG_SJ

,JG_SJ

,KFJS_QX

,QD_RQ

,PZ_WH

,PZ_RQ

,PZ_JG,KFTZ_ZE

,CL_XZCR_MJ

,CL_GBXZCR_MJ

,CL_QT_MJ

,PC_MJ

,GY_WLD_MJ

,CL_XQ

,PZ_DW,CL_CR_MJ,

JK_GC,PC_CR_MJ,CL_MJ

,SJ_JD_SJ

,SJ_DG_SJ

,SJ_JG_SJ

,MIN_JZ_MD_TAG

,MAX_JZ_MD_TAG

,MIN_RJL_TAG

,MAX_RJL_TAG

,MIN_LHL_TAG

,MAX_LHL_TAG

,MIN_JZ_GD_TAG

,MAX_JZ_GD_TAG

,HT_LX

,KFLY_BZ

,WKFLY_YY

,SF_SH

,XZ_ZT

,QY_SS_LX

,LSXZ_ZT

,HAVE_JZD

,SRR

,CX_YY

,IS_STOP

,ZJGG_MJ

,GDXM_GZZT,

BG_DG_SJ,

BG_JG_SJ

,BG_JD_SJ,CONSTRAINT "pk_T_GDXM" PRIMARY KEY (GD_GUID) RELY DISABLE

) AS

SELECT A.GD_GUID,D.ZD_GUID ZD_GUID,XZQ XZQ_DM

,B.XM_GUID

,XM_ZT

---XM_XH

,0 XM_XH

,XMBH BH

--DZ_BA_BH

,'' DZ_BA_BH

,JSXM_MC XM_MC

,TZZT_XZ

,HYFL HY_FL

,TDJB TD_JB

,ZDBH ZD_BH

,TDZL TD_ZL

, ZMJ GD_ZMJ

, GDFS GY_FS

,HBMJ GY_MJ

,HB_XZCR_MJ XZ_MJ

,SQYD_YT TD_YT

--CR_NX,YT_SM,

,0 CR_NX

,'' YT_SM

,YDJD_SJ JD_SJ

,D.HBJK JE

,G.GY_TZE GDZC_TZE

,GY_TZQD TZ_QD

,F.ZT_JSW_XZ ZT_JZ_XZ

,FS_JSW_XZ FS_JZ_XZ

,ZMJ JZ_MJ

,JZMD_MIN MIN_JZ_MD

,JZMD_MAX MAX_JZ_MD

,RJL_MIN MIN_RJL

,RJL_MAX MAX_RJL

,LDL_MIN MIN_LHL

,LDL_MAX MAX_LHL

,JZXG_MIN MIN_JZ_GD

,JZXG_MAX MAX_JZ_GD

,QTYQ QT_TD_YQ

,YDDG_SJ DG_SJ

,YDJG_SJ JG_SJ

--,KFJS_QX

,0 KFJS_QX

,CASE GDFS WHEN '1' THEN I.QFRQ

ELSE J.QDRQ

END QD_RQ

,K.PZWH PZ_WH

,K.ZF_PZSJ PZ_RQ

,K.PZJG PZ_JG

,-FGY_TZE KFTZ_ZE

,HB_XZCR_MJ CL_XZCR_MJ

,HB_GBXZ_MJ CL_GBXZCR_MJ

,QT_CLMJ CL_QT_MJ

--,PC_MJ

,0 PC_MJ

,GY_WLY GY_WLD_MJ

,HTXQ CL_XQ

--,PZ_DW,CL_CR_MJ,

,'' PZ_DW,0 CL_CR_MJ

--JK_GC,PC_CR_MJ,CL_MJ

,'' JK_GC,0 PC_CR_MJ,0 CL_MJ

,SJ_JD_SJ

,SJ_KG_SJ SJ_DG_SJ

,SJ_JG_SJ

,JZMD_MIN_TAG MIN_JZ_MD_TAG

,JZMD_MAX_TAG MAX_JZ_MD_TAG

,RJL_MIN_TAG MIN_RJL_TAG

,RJL_MAX_TAG MAX_RJL_TAG

,LDL_MIN_TAG MIN_LHL_TAG

,LDL_MAX_TAG MAX_LHL_TAG

,JZXG_MIN_TAG MIN_JZ_GD_TAG

,JZXG_MAX_TAG MAX_JZ_GD_TAG

,1 HT_LX

,1 KFLY_BZ

,'' WKFLY_YY

,0 SF_SH

,-1 XZ_ZT

,'' QY_SS_LX

,-1 LSXZ_ZT

,1 HAVE_JZD

,B.SQYD_DW SRR

,'' CX_YY

,'' IS_STOP

,0 ZJGG_MJ

,XM_ZT GDXM_GZZT,

--YD 交地、动工、竣工 BG_JD_SJ,BG_DG_SJ,BG_JG_SJ

YDDG_SJ BG_DG_SJ,

YDJG_SJ BG_JG_SJ

,YDJD_SJ BG_JD_SJ

FROM T_GD_YWBH A INNER JOIN

T_GD_XMXX B ON A.GD_GUID=B.GD_GUID

LEFT JOIN T_KC_KCDJ_CG C ON B.XM_GUID=C.XM_GUID

LEFT JOIN T_KC_ZDXX D ON C.CHCG_GUID=D.CHCG_GUID

LEFT JOIN T_GD_XMXX_KZ_GYMJ E ON B.XM_GUID=E.XM_GUID

LEFT JOIN T_KF_KFLY_YD F ON B.XM_GUID=F.XM_GUID

LEFT JOIN T_KF_TZQD_YD G ON G.KFLY_GUID=F.KFLY_GUID

LEFT JOIN T_KF_CRTJ_YD H ON H.KFLY_GUID=F.KFLY_GUID

LEFT JOIN T_HBJDS I ON B.XM_GUID=I.XM_GUID

LEFT JOIN T_HT_CRHT J ON B.XM_GUID=J.XM_GUID

LEFT JOIN T_SP_SPXX K ON B.XM_GUID=K.XM_GUID

WHERE B.MARK=0;