请教定时转存问题 本帖最后由 bjwangzhou 于 2011-04-01 09:43:32 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你的语法上有些问题。改成如下。mysql> DELIMITER $$mysql>mysql> create procedure trans() -> -> begin -> -> insert into traffic_13_t -> select * from traffic_46_t -> where cast(log_date as datetime) < (current_date() - Interval 1 DAY); -> -> delete from traffic_46_t -> where cast(log_date as datetime) < (current_date() - Interval 1 DAY); -> -> end $$Query OK, 0 rows affected (0.12 sec)mysql>mysql> DELIMITER ;mysql> create event event_everyday -> ON SCHEDULE EVERY 1 DAY -> STARTS TIMESTAMP('2011-04-01 00:00:00') -> on completion preserve enable -> do call trans();Query OK, 0 rows affected (0.00 sec)mysql> alter event event_everyday -> on completion preserve enable;Query OK, 0 rows affected (0.00 sec)mysql> 当您的问题得到解答后请及时结贴.http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.htmlhttp://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.htmlhttp://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?http://community.csdn.net/Help/HelpCenter.htm#结帖 error 1064(4200) delimiter $$ timestamp('2011-04-01 00:00:00')=_=! Mysql二进制日志同步问题? 数据库并发处理 数据库设计??难呀! 把结果集中相同类型数据显示三条。 请教大家关于MYSQL优化的问题? 请教关于备份的问题 mysql同一个字段下有的是值有的是问号 我在MYSQL下误删了数据,我要怎样才能恢复过来? 希奇希奇真希奇,麻雀踩死老母鸡!!! 如何用jbuilder访问mysql? 请帮忙! mysql 唯一索引和普通索引 BUG mysql 查寻过滤问题请教。
mysql>
mysql> create procedure trans()
->
-> begin
->
-> insert into traffic_13_t
-> select * from traffic_46_t
-> where cast(log_date as datetime) < (current_date() - Interval 1 DAY);
->
-> delete from traffic_46_t
-> where cast(log_date as datetime) < (current_date() - Interval 1 DAY);
->
-> end $$
Query OK, 0 rows affected (0.12 sec)mysql>
mysql> DELIMITER ;
mysql> create event event_everyday
-> ON SCHEDULE EVERY 1 DAY
-> STARTS TIMESTAMP('2011-04-01 00:00:00')
-> on completion preserve enable
-> do call trans();
Query OK, 0 rows affected (0.00 sec)mysql> alter event event_everyday
-> on completion preserve enable;
Query OK, 0 rows affected (0.00 sec)mysql>
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
timestamp('2011-04-01 00:00:00')=_=!