1、新建脚本:
mysql -uroot -e "use databaseAAA;UPDATE phome_ecms_BBB SET startime = unix_timestamp(now()) , endtime = UNIX_TIMESTAMP(timestampadd(minute, 55, from_unixtime(startime))) WHERE tvid LIKE 'CCC%';"
2、启用计划任务
(以上适用于appnode面板)
参考:
1、新建脚本:
mysql -uroot -e "use databaseAAA;UPDATE phome_ecms_BBB SET startime = unix_timestamp(now()) , endtime = UNIX_TIMESTAMP(timestampadd(minute, 55, from_unixtime(startime))) WHERE tvid LIKE 'CCC%';"
2、启用计划任务
(以上适用于appnode面板)
参考: