6 lines
479 B
SQL
6 lines
479 B
SQL
INSERT INTO `la_dev_crontab` (`name`, `type`, `system`, `remark`, `command`, `params`, `status`, `expression`, `create_time`, `update_time`)
|
|
SELECT '台湾彩券资讯采集', 1, 0, '拉取台湾彩券官网新闻并写入彩票资讯分类', 'crawler', 'taiwan_lottery_news', 1, '15 */2 * * *', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM `la_dev_crontab` WHERE `command` = 'crawler' AND `params` = 'taiwan_lottery_news' AND `delete_time` IS NULL
|
|
);
|