MySQL触发器

BEGIN  
    SET new.crawtime=NOW();  
    END

未完...

SELECT * FROM `ptf_crawl` LEFT JOIN `ptf_crawl_text` ON `ptf_crawl`.`crawl_id` = `ptf_crawl_text`.`crawl_id` WHERE `ptf_crawl`.`crawl_id` IS NULL;

SELECT NOW();
SELECT CURRENT_DATE;
SELECT CURRENT_TIME;

原文地址:https://www.cnblogs.com/tomcattd/p/3506600.html