新建空白账套后导入基础资料

资料可能不全，请注意检查！

— 小心同义词 小心同义词 小心同义词！！！
–DELETE FROM sma_file WHERE 1=1;
INSERT INTO sma_file SELECT * FROM ltcc.sma_file;
–DELETE FROM smb_file WHERE 1=1;
INSERT INTO smb_file SELECT * FROM ltcc.smb_file;
–DELETE FROM smc_file WHERE 1=1;
INSERT INTO smc_file SELECT * FROM ltcc.smc_file;
DELETE FROM smd_file WHERE 1=1;
INSERT INTO smd_file SELECT * FROM ltcc.smd_file;
DELETE FROM sme_file WHERE 1=1;
INSERT INTO sme_file SELECT * FROM ltcc.sme_file;
DELETE FROM smy_file WHERE 1=1;
INSERT INTO smy_file SELECT * FROM ltcc.smy_file;

DELETE FROM aza_file WHERE 1=1;
INSERT INTO aza_file SELECT * FROM ltcc.aza_file;
DELETE FROM azf_file WHERE 1=1;
INSERT INTO azf_file SELECT * FROM ltcc.azf_file;
DELETE FROM azi_file WHERE 1=1;
INSERT INTO azi_file SELECT * FROM ltcc.azi_file;
DELETE FROM azj_file WHERE 1=1;
INSERT INTO azj_file SELECT * FROM ltcc.azj_file;
DELETE FROM azk_file WHERE 1=1;
INSERT INTO azk_file SELECT * FROM ltcc.azk_file;
DELETE FROM azm_file WHERE 1=1;
INSERT INTO azm_file SELECT * FROM ltcc.azm_file;
DELETE FROM azmm_file WHERE 1=1;
INSERT INTO azmm_file SELECT * FROM ltcc.azmm_file;
DELETE FROM azn_file WHERE 1=1;
INSERT INTO azn_file SELECT * FROM ltcc.azn_file;
DELETE FROM aznn_file WHERE 1=1;
INSERT INTO aznn_file SELECT * FROM ltcc.aznn_file;

DELETE FROM aaa_file WHERE 1=1;
INSERT INTO aaa_file SELECT * FROM ltcc.aaa_file;
DELETE FROM aab_file WHERE 1=1;
INSERT INTO aab_file SELECT * FROM ltcc.aab_file;
DELETE FROM aac_file WHERE 1=1;
INSERT INTO aac_file SELECT * FROM ltcc.aac_file;
DELETE FROM aad_file WHERE 1=1;
INSERT INTO aad_file SELECT * FROM ltcc.aad_file;
DELETE FROM aae_file WHERE 1=1;
INSERT INTO aae_file SELECT * FROM ltcc.aae_file;
–DELETE FROM aag_file WHERE 1=1;
–INSERT INTO aag_file SELECT * FROM ltcc.aag_file;
DELETE FROM aaz_file WHERE 1=1;
INSERT INTO aaz_file SELECT * FROM ltcc.aaz_file;

–DELETE FROM gea_file WHERE 1=1;
–INSERT INTO gea_file SELECT * FROM ltcc.gea_file;
DELETE FROM geb_file WHERE 1=1;
INSERT INTO geb_file SELECT * FROM ltcc.geb_file;
DELETE FROM gec_file WHERE 1=1;
INSERT INTO gec_file SELECT * FROM ltcc.gec_file;
DELETE FROM ged_file WHERE 1=1;
INSERT INTO ged_file SELECT * FROM ltcc.ged_file;
–DELETE FROM gen_file WHERE 1=1;
–INSERT INTO gen_file SELECT * FROM ltcc.gen_file;
–DELETE FROM gem_file WHERE 1=1;
–INSERT INTO gem_file SELECT * FROM ltcc.gem_file;
DELETE FROM geo_file WHERE 1=1;
INSERT INTO geo_file SELECT * FROM ltcc.geo_file;

DELETE FROM ahe_file WHERE 1=1;
INSERT INTO ahe_file SELECT * FROM ltcc.ahe_file;
DELETE FROM ahf_file WHERE 1=1;
INSERT INTO ahf_file SELECT * FROM ltcc.ahf_file;
DELETE FROM ahh_file WHERE 1=1;
INSERT INTO ahh_file SELECT * FROM ltcc.ahh_file;

DELETE FROM mai_file WHERE 1=1;
INSERT INTO mai_file SELECT * FROM ltcc.mai_file;
DELETE FROM maj_file WHERE 1=1;
INSERT INTO maj_file SELECT * FROM ltcc.maj_file;

DELETE FROM pja_file WHERE 1=1;
INSERT INTO pja_file SELECT * FROM ltcc.pja_file;
DELETE FROM pjb_file WHERE 1=1;
INSERT INTO pjb_file SELECT * FROM ltcc.pjb_file;

DELETE FROM gfe_file WHERE 1=1;
INSERT INTO gfe_file SELECT * FROM ltcc.gfe_file;

DELETE FROM aee_file WHERE 1=1;
INSERT INTO aee_file SELECT * FROM ltcc.aee_file;

DELETE FROM ool_file WHERE 1=1;
INSERT INTO ool_file SELECT * FROM ltcc.ool_file;
DELETE FROM oom_file WHERE 1=1;
INSERT INTO oom_file SELECT * FROM ltcc.oom_file;
DELETE FROM oon_file WHERE 1=1;
INSERT INTO oon_file SELECT * FROM ltcc.oon_file;
DELETE FROM ooz_file WHERE 1=1;
INSERT INTO ooz_file SELECT * FROM ltcc.ooz_file;
DELETE FROM ooy_file WHERE 1=1;
INSERT INTO ooy_file SELECT * FROM ltcc.ooy_file;

DELETE FROM apl_file WHERE 1=1;
INSERT INTO apl_file SELECT * FROM ltcc.apl_file;
DELETE FROM apr_file WHERE 1=1;
INSERT INTO apr_file SELECT * FROM ltcc.apr_file;
DELETE FROM aps_file WHERE 1=1;
INSERT INTO aps_file SELECT * FROM ltcc.aps_file;
DELETE FROM apt_file WHERE 1=1;
INSERT INTO apt_file SELECT * FROM ltcc.apt_file;
DELETE FROM apy_file WHERE 1=1;
INSERT INTO apy_file SELECT * FROM ltcc.apy_file;
DELETE FROM apz_file WHERE 1=1;
INSERT INTO apz_file SELECT * FROM ltcc.apz_file;

DELETE FROM nma_file WHERE 1=1;
INSERT INTO nma_file SELECT * FROM ltcc.nma_file;
DELETE FROM nmb_file WHERE 1=1;
INSERT INTO nmb_file SELECT * FROM ltcc.nmb_file;
DELETE FROM nmc_file WHERE 1=1;
INSERT INTO nmc_file SELECT * FROM ltcc.nmc_file;
DELETE FROM nmj_file WHERE 1=1;
INSERT INTO nmj_file SELECT * FROM ltcc.nmj_file;
DELETE FROM nmk_file WHERE 1=1;
INSERT INTO nmk_file SELECT * FROM ltcc.nmk_file;
DELETE FROM nml_file WHERE 1=1;
INSERT INTO nml_file SELECT * FROM ltcc.nml_file;
DELETE FROM nmo_file WHERE 1=1;
INSERT INTO nmo_file SELECT * FROM ltcc.nmo_file;
DELETE FROM nmq_file WHERE 1=1;
INSERT INTO nmq_file SELECT * FROM ltcc.nmq_file;
DELETE FROM nms_file WHERE 1=1;
INSERT INTO nms_file SELECT * FROM ltcc.nms_file;
DELETE FROM nmt_file WHERE 1=1;
INSERT INTO nmt_file SELECT * FROM ltcc.nmt_file;
DELETE FROM nmw_file WHERE 1=1;
INSERT INTO nmw_file SELECT * FROM ltcc.nmw_file;
DELETE FROM nmy_file WHERE 1=1;
INSERT INTO nmy_file SELECT * FROM ltcc.nmy_file;
DELETE FROM nmz_file WHERE 1=1;
INSERT INTO nmz_file SELECT * FROM ltcc.nmz_file;

DELETE FROM faa_file WHERE 1=1;
INSERT INTO faa_file SELECT * FROM ltcc.faa_file;
DELETE FROM fab_file WHERE 1=1;
INSERT INTO fab_file SELECT * FROM ltcc.fab_file;
DELETE FROM fac_file WHERE 1=1;
INSERT INTO fac_file SELECT * FROM ltcc.fac_file;
DELETE FROM faf_file WHERE 1=1;
INSERT INTO faf_file SELECT * FROM ltcc.faf_file;
DELETE FROM fag_file WHERE 1=1;
INSERT INTO fag_file SELECT * FROM ltcc.fag_file;
DELETE FROM fah_file WHERE 1=1;
INSERT INTO fah_file SELECT * FROM ltcc.fah_file;
DELETE FROM fai_file WHERE 1=1;
INSERT INTO fai_file SELECT * FROM ltcc.fai_file;

DELETE FROM ccz_file WHERE 1=1;
INSERT INTO ccz_file SELECT * FROM ltcc.ccz_file;

DELETE FROM pma_file WHERE 1=1;
INSERT INTO pma_file SELECT * FROM ltcc.pma_file;
DELETE FROM pmd_file WHERE 1=1;
INSERT INTO pmd_file SELECT * FROM ltcc.pmd_file;
DELETE FROM pme_file WHERE 1=1;
INSERT INTO pme_file SELECT * FROM ltcc.pme_file;
DELETE FROM pmf_file WHERE 1=1;
INSERT INTO pmf_file SELECT * FROM ltcc.pmf_file;
DELETE FROM pmg_file WHERE 1=1;
INSERT INTO pmg_file SELECT * FROM ltcc.pmg_file;
DELETE FROM pmy_file WHERE 1=1;
INSERT INTO pmy_file SELECT * FROM ltcc.pmy_file;

DELETE FROM oab_file WHERE 1=1;
INSERT INTO oab_file SELECT * FROM ltcc.oab_file;
DELETE FROM oac_file WHERE 1=1;
INSERT INTO oac_file SELECT * FROM ltcc.oac_file;
DELETE FROM oae_file WHERE 1=1;
INSERT INTO oae_file SELECT * FROM ltcc.oae_file;
DELETE FROM oaf_file WHERE 1=1;
INSERT INTO oaf_file SELECT * FROM ltcc.oaf_file;
DELETE FROM oag_file WHERE 1=1;
INSERT INTO oag_file SELECT * FROM ltcc.oag_file;
DELETE FROM oah_file WHERE 1=1;
INSERT INTO oah_file SELECT * FROM ltcc.oah_file;
DELETE FROM oaj_file WHERE 1=1;
INSERT INTO oaj_file SELECT * FROM ltcc.oaj_file;
DELETE FROM oay_file WHERE 1=1;
INSERT INTO oay_file SELECT * FROM ltcc.oay_file;
DELETE FROM oaz_file WHERE 1=1;
INSERT INTO oaz_file SELECT * FROM ltcc.oaz_file;

DELETE FROM ocg_file WHERE 1=1;
INSERT INTO ocg_file SELECT * FROM ltcc.ocg_file;
DELETE FROM oba_file WHERE 1=1;
INSERT INTO oba_file SELECT * FROM ltcc.oba_file;
DELETE FROM obb_file WHERE 1=1;
INSERT INTO obb_file SELECT * FROM ltcc.obb_file;

DELETE FROM qcz_file WHERE 1=1;
INSERT INTO qcz_file SELECT * FROM ltcc.qcz_file;
DELETE FROM qca_file WHERE 1=1;
INSERT INTO qca_file SELECT * FROM ltcc.qca_file;
DELETE FROM qcb_file WHERE 1=1;
INSERT INTO qcb_file SELECT * FROM ltcc.qcb_file;
DELETE FROM qcc_file WHERE 1=1;
INSERT INTO qcc_file SELECT * FROM ltcc.qcc_file;
DELETE FROM qcd_file WHERE 1=1;
INSERT INTO qcd_file SELECT * FROM ltcc.qcd_file;
DELETE FROM qce_file WHERE 1=1;
INSERT INTO qce_file SELECT * FROM ltcc.qce_file;
DELETE FROM qck_file WHERE 1=1;
INSERT INTO qck_file SELECT * FROM ltcc.qck_file;

DELETE FROM doc_file WHERE 1=1;
INSERT INTO doc_file SELECT * FROM ltcc.doc_file;

DELETE FROM pnz_file WHERE 1=1;
INSERT INTO pnz_file SELECT * FROM ltcc.pnz_file;

DELETE FROM pnq_file WHERE 1=1;
INSERT INTO pnq_file SELECT * FROM ltcc.pnq_file;

DELETE FROM tc_hff_file WHERE 1=1;
INSERT INTO tc_hff_file SELECT * FROM ltcc.tc_hff_file;
DELETE FROM tc_hfy_file WHERE 1=1;
INSERT INTO tc_hfy_file SELECT * FROM ltcc.tc_hfy_file;

转载请注明：赫非域 » 新建空白账套后导入基础资料