mysql定时创建数据表_mysql定时任务按天建表并跨库同步数据syncnavigator

在线QQ客服：1922638

专业的SQL Server、MySQL数据库同步软件

转载请附上博文链接！版权申明:本文为博主原创文章。

每天自动从小云AI对话详情表同步数据。成立定时任务实现:建立ASR识别记录表。

*/

DROPPROCEDUREIFEXISTS`create_o_asr_record_call`;

DELIMITER;;

outresultintCREA TEPROCEDURE`create_o_asr_record_call`IN`dayInt`bigint.

COMMENT\’A SR识别功效表–按日–建表\’

BEGIN

dayInt,set@sql_tmp3=CONCA T\’creattablo_asr_record_\’.\’likeo_asr_record_0\’;

PREPA REstmt3FROM@sql_tmp3;

EXECUTEstmt3;

DEA LLOCA TEPREPA REstmt3;

\’tb_ucpaas_engine_\’,set@engine_tab=CONCA T\’uc_ipcc_cloud_ai_stat.\’.DA TE_FORMA Tdate_subcurdat,interv1dai,\’%Y%m%d\’;

CONCA T\’o_asr_record_\’,set@sql_tmp_insert=CONCA T\’INSERTINTO\’.dayInt,\’`callid`,`derial_number`,`content`,`record_url`\’,\’selectcallid,derial_number,text,record_urlfrom\’,@engine_tab;

PREPA REstmt_insertFROM@sql_tmp_insert;

EXECUTEstmt_insert;

DEA LLOCA TEPREPA REstmt_insert;

setresult=1;

END

;;

DELIMITER;

–成立定时使命

DELIMITER//

DROPEVENTIFEXISTSevent_sync_asr_record//

CREA TEEVENTevent_sync_asr_record

interv30HOUR_MINUTEonschedulEVERY1DA YSTA RTSdate_addcurdat.

do

BEGIN

\’%Y%m%d\’,callcreate_o_asr_record_calDA TE_FORMA Tnow.@1;

END//

DELIMITER;

create_o_asr_record_call

create_o_asr_record_call

———————

作者:Jeff.Sheng

来历:CSDN

原文:https://blog.csdn.net/shengqianfeng/article/details/80270695