这个mysql触发器怎么写呀??一个到特定时间全部清空一个表的触发器。 到每周日晚23:50自动清空一个表的全部内容~~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1. 操作系统中的计划任务(WINDOWS)或CRONTABL(LINUX/UNIX)2。MYSQL版本5.1以上,create eventCREATE [DEFINER = { user | CURRENT_USER }] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'comment'] DO sql_statement;schedule: AT timestamp [+ INTERVAL interval] ... | EVERY interval [STARTS timestamp [+ INTERVAL interval] ...] [ENDS timestamp [+ INTERVAL interval] ...]interval: quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE | WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE | DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}mysql> SELECT NOW();+---------------------+| NOW() |+---------------------+| 2006-02-10 23:59:01 |+---------------------+1 row in set (0.04 sec)mysql> CREATE EVENT e_totals -> ON SCHEDULE AT '2006-02-10 23:59:00' -> DO INSERT INTO test.totals VALUES (NOW());Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> SHOW WARNINGS\G*************************** 1. row *************************** Level: Note Code: 1588Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation. create event 定时deletemysql> CREATE EVENT e_totals -> ON SCHEDULE AT '2006-02-10 23:59:00' -> DO INSERT INTO test.totals VALUES (NOW()); Query OK, 0 rows affected, 1 warning (0.00 sec) 像版主提供的 你可以在红色部分删除你的表 楼主也太懒了,照着语法自己埴一下空都要找人来做。mysql> CREATE EVENT -> event_name -> ON SCHEDULE EVERY 1 DAY STARTS '2009-09-20 23:40:00' -> DO delete from t2;Query OK, 0 rows affected (0.14 sec) 这个建议用mysql本上的event来实现;也可以用操作系统的计划任务来处理;或自己写个程序用定时器来触发。 提醒一下楼主,必须是mysql5.1的版本以上的才有这个功能 请问MYSQL如何查询结果后随机排序 联合查询表的问题请教 freebsd下MYSQL安装问题 急!!!mysql中的部分数据库部分表突然无法查询 mysql 误删表中数据 能恢复原数据吗 postgresql用户定义c函数的调试 mysql like语句有问题 安装mysql时出现10061错误,急!!!!! 关于MySQL的几个问题 如何用java查询数据库中有中文字段的表? 如何删除这些完整性约束条件 mysql临时表的问题
2。MYSQL版本5.1以上,create eventCREATE
[DEFINER = { user | CURRENT_USER }]
EVENT
[IF NOT EXISTS]
event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE | DISABLE | DISABLE ON SLAVE]
[COMMENT 'comment']
DO sql_statement;schedule:
AT timestamp [+ INTERVAL interval] ...
| EVERY interval
[STARTS timestamp [+ INTERVAL interval] ...]
[ENDS timestamp [+ INTERVAL interval] ...]interval:
quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
mysql> SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2006-02-10 23:59:01 |
+---------------------+
1 row in set (0.04 sec)mysql> CREATE EVENT e_totals
-> ON SCHEDULE AT '2006-02-10 23:59:00'
-> DO INSERT INTO test.totals VALUES (NOW());
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> SHOW WARNINGS\G
*************************** 1. row ***************************
Level: Note
Code: 1588
Message: Event execution time is in the past and ON COMPLETION NOT
PRESERVE is set. The event was dropped immediately after
creation.
mysql> CREATE EVENT e_totals
-> ON SCHEDULE AT '2006-02-10 23:59:00'
-> DO INSERT INTO test.totals VALUES (NOW()); Query OK, 0 rows affected, 1 warning (0.00 sec) 像版主提供的 你可以在红色部分删除你的表
mysql> CREATE EVENT
-> event_name
-> ON SCHEDULE EVERY 1 DAY STARTS '2009-09-20 23:40:00'
-> DO delete from t2;
Query OK, 0 rows affected (0.14 sec)
也可以用操作系统的计划任务来处理;
或自己写个程序用定时器来触发。