http://www.cnblogs.com/flish/archive/2011/08/08/2131031.html
http://download.csdn.net/detail/eaglet/521857#comment
http://ictclas.nlpir.org/
http://www.xuebuyuan.com/575842.html
client_ID = 2299723665
client_SERCRET = af784b4e0fc05c7e2ff7bc9c7453c3f6
http://www.donews.com/net/201601/2914550.shtm
三表联合查询:
select t.ID,t.PROD_NAME,t.CONTENT,t.USER_CHS_NAME,t.CRT_TS,t2.`NAME`,t2.`VALUE` from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.`NAME` order by t.CRT_TS desc;
select count(t.ID) from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.NAME order by t.CRT_TS desc;
select count(t.ID) from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.NAME;
--修改视图
ALTER VIEW viw_tdcsp_login_log
AS select `tbl_tdcsp_login_log1`.`rec_id` AS `rec_id`,`tbl_tdcsp_login_log1`.`submit_mon` AS `submit_mon`,`tbl_tdcsp_login_log1`.`oper_ts` AS `oper_ts`,`tbl_tdcsp_login_log1`.`user_id` AS `user_id`,`tbl_tdcsp_login_log1`.`oper_rslt` AS `oper_rslt`,`tbl_tdcsp_login_log1`.`oper_ip` AS `oper_ip`,`tbl_tdcsp_login_log1`.`rec_upd_ts` AS `rec_upd_ts`,`tbl_tdcsp_login_log1`.`rec_crt_ts` AS `rec_crt_ts`,`tbl_tdcsp_login_log1`.`sys_id` AS `sys_id`,`tbl_tdcsp_login_log1`.`USER_CHS_NAME` AS `USER_CHS_NAME`,`tbl_tdcsp_login_log1`.`ORGID` AS `ORGID`,`tbl_tdcsp_login_log1`.`GORGID` AS `GORGID`,`tbl_tdcsp_login_log1`.`ORGNAME` AS `ORGNAME`,`tbl_tdcsp_login_log1`.`GORNAME` AS `GORNAME` from `tbl_tdcsp_login_log1` union all select `tbl_tdcsp_login_log2`.`rec_id` AS `rec_id`,`tbl_tdcsp_login_log2`.`submit_mon` AS `submit_mon`,`tbl_tdcsp_login_log2`.`oper_ts` AS `oper_ts`,`tbl_tdcsp_login_log2`.`user_id` AS `user_id`,`tbl_tdcsp_login_log2`.`oper_rslt` AS `oper_rslt`,`tbl_tdcsp_login_log2`.`oper_ip` AS `oper_ip`,`tbl_tdcsp_login_log2`.`rec_upd_ts` AS `rec_upd_ts`,`tbl_tdcsp_login_log2`.`rec_crt_ts` AS `rec_crt_ts`,`tbl_tdcsp_login_log2`.`sys_id` AS `sys_id`,`tbl_tdcsp_login_log2`.`USER_CHS_NAME` AS `USER_CHS_NAME`,`tbl_tdcsp_login_log2`.`ORGID` AS `ORGID`,`tbl_tdcsp_login_log2`.`GORGID` AS `GORGID`,`tbl_tdcsp_login_log2`.`ORGNAME` AS `ORGNAME`,`tbl_tdcsp_login_log2`.`GORNAME` AS `GORNAME` from `tbl_tdcsp_login_log2`;
--修改tbl_tdcsp_login_log1、tbl_tdcsp_login_log2
ALTER TABLE tbl_tdcsp_login_log1 ADD
(USER_CHS_NAME varchar(36) CHARACTER SET gbk COLLATE gbk_bin DEFAULT NULL,
ORGID int(11) DEFAULT NULL,
ORGNAME varchar(32) DEFAULT NULL,
GORGID int(11) DEFAULT NULL,
GORNAME varchar(32) DEFAULT NULL);
--修改tbl_tdcsp_organization_local
ALTER TABLE tbl_tdcsp_organization_local ADD ORGLEVEL varchar(4) COLLATE gbk_bin DEFAULT NULL;
http://download.csdn.net/detail/eaglet/521857#comment
http://ictclas.nlpir.org/
http://www.xuebuyuan.com/575842.html
client_ID = 2299723665
client_SERCRET = af784b4e0fc05c7e2ff7bc9c7453c3f6
http://www.donews.com/net/201601/2914550.shtm
三表联合查询:
select t.ID,t.PROD_NAME,t.CONTENT,t.USER_CHS_NAME,t.CRT_TS,t2.`NAME`,t2.`VALUE` from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.`NAME` order by t.CRT_TS desc;
select count(t.ID) from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.NAME order by t.CRT_TS desc;
select count(t.ID) from tbl_tdcsp_comment t left join tbl_tdcsp_prod_info t1 on t.PROD_ID=t1.ID left join tbl_tdcsp_data_dict t2 on t1.CATALOG=t2.NAME;
--修改视图
ALTER VIEW viw_tdcsp_login_log
AS select `tbl_tdcsp_login_log1`.`rec_id` AS `rec_id`,`tbl_tdcsp_login_log1`.`submit_mon` AS `submit_mon`,`tbl_tdcsp_login_log1`.`oper_ts` AS `oper_ts`,`tbl_tdcsp_login_log1`.`user_id` AS `user_id`,`tbl_tdcsp_login_log1`.`oper_rslt` AS `oper_rslt`,`tbl_tdcsp_login_log1`.`oper_ip` AS `oper_ip`,`tbl_tdcsp_login_log1`.`rec_upd_ts` AS `rec_upd_ts`,`tbl_tdcsp_login_log1`.`rec_crt_ts` AS `rec_crt_ts`,`tbl_tdcsp_login_log1`.`sys_id` AS `sys_id`,`tbl_tdcsp_login_log1`.`USER_CHS_NAME` AS `USER_CHS_NAME`,`tbl_tdcsp_login_log1`.`ORGID` AS `ORGID`,`tbl_tdcsp_login_log1`.`GORGID` AS `GORGID`,`tbl_tdcsp_login_log1`.`ORGNAME` AS `ORGNAME`,`tbl_tdcsp_login_log1`.`GORNAME` AS `GORNAME` from `tbl_tdcsp_login_log1` union all select `tbl_tdcsp_login_log2`.`rec_id` AS `rec_id`,`tbl_tdcsp_login_log2`.`submit_mon` AS `submit_mon`,`tbl_tdcsp_login_log2`.`oper_ts` AS `oper_ts`,`tbl_tdcsp_login_log2`.`user_id` AS `user_id`,`tbl_tdcsp_login_log2`.`oper_rslt` AS `oper_rslt`,`tbl_tdcsp_login_log2`.`oper_ip` AS `oper_ip`,`tbl_tdcsp_login_log2`.`rec_upd_ts` AS `rec_upd_ts`,`tbl_tdcsp_login_log2`.`rec_crt_ts` AS `rec_crt_ts`,`tbl_tdcsp_login_log2`.`sys_id` AS `sys_id`,`tbl_tdcsp_login_log2`.`USER_CHS_NAME` AS `USER_CHS_NAME`,`tbl_tdcsp_login_log2`.`ORGID` AS `ORGID`,`tbl_tdcsp_login_log2`.`GORGID` AS `GORGID`,`tbl_tdcsp_login_log2`.`ORGNAME` AS `ORGNAME`,`tbl_tdcsp_login_log2`.`GORNAME` AS `GORNAME` from `tbl_tdcsp_login_log2`;
--修改tbl_tdcsp_login_log1、tbl_tdcsp_login_log2
ALTER TABLE tbl_tdcsp_login_log1 ADD
(USER_CHS_NAME varchar(36) CHARACTER SET gbk COLLATE gbk_bin DEFAULT NULL,
ORGID int(11) DEFAULT NULL,
ORGNAME varchar(32) DEFAULT NULL,
GORGID int(11) DEFAULT NULL,
GORNAME varchar(32) DEFAULT NULL);
--修改tbl_tdcsp_organization_local
ALTER TABLE tbl_tdcsp_organization_local ADD ORGLEVEL varchar(4) COLLATE gbk_bin DEFAULT NULL;