-- update 操作的触发器例子drop trigger if exists csf_maec.tri_economic_dt_update;delimiter |create trigger csf_maec.tri_economic_dt_update after update on csf_maec.maec_datafor each row begin insert into csf_maec.maec_data_ecnomic( data_id, ...【阅读全文】
[i=s] 本帖最后由 mchdba 于 2011-10-21 10:50 编辑 cdp.listed_cpny_fin_rpt_prd表总记录数:1467246test.qa_cpny表总记录数:103explain SELECT dat.* FROM test.qa_cpny es force index(PRIMARY) inner join cdp.listed_cpny_fin_rpt_prd dat on (es.excel_id = dat.excel_id)&n...【阅读全文】