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;

posted @ 2014-01-06 09:07  杨桃  阅读(114)  评论(0编辑  收藏  举报