请教定时转存问题 本帖最后由 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')=_=! 导入数据库报错#1067 - Invalid default value for 'Author' Dreamweaver 连接数据库—记录集 问题 SQL条件插入大问题!!高手快来啊! VC编程下如何得到MySQL表中某一列中的最小值? Mysql中的数据备份问题 设了主键 却能设为空 如何理解和解决? 复制环境 1亿的大表删除数据 一个MySQL的数据库的问题 mysql 的安装问题 --急! Mysql如何在触发器内执行多条sql 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')=_=!