摘要: --每天定时00:00:00更新SQLdrop EVENT `Reset_tbidentity`;CREATE event if not exists `Reset_tbidentity`ON SCHEDULE EVERY 1 DAY STARTS concat(current_date,' 00:00:00')ON COMPLETION PRESERVEENABLEDOUPDATE tbidentity SET Identity =0;alter event Reset_tbidentity ONCOMPLETION PRESERVE ENABLE; 阅读全文
posted @ 2013-09-26 10:49 小さいです哥 阅读(579) 评论(0) 推荐(0)