mysql如何写事件????

CREATE EVENT [事件名]

ON SCHEDULE EVERY 7 WEEK STARTS

'2014-05-14 04:00:00'

ON COMPLETION PRESERVE

ENABLE

DO

[要执行的sql语句]

添加 执行SQL 语句后在来个 查询 影响行数

添加语句

$num = mysql_num_rows($result)

然后判断如果影响行数不等于0就执行删除

if($num！=0)｛

删除语句

｝

---