单击按钮创建mysql事件,每隔5分钟删除表的第一行吗? [英] create mysql event on button click, to delete the first row of table every 5 minutes?
本文介绍了单击按钮创建mysql事件,每隔5分钟删除表的第一行吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是我的php页面,单击按钮即可调用.
Here is my php page which is called on button click.
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="parth"; // Database name
$con = mysql_connect("localhost","root","") or die('Could not connect to MySQL server: ' . mysql_error());
//echo"Connected to MySQL server";
mysql_select_db("parth") or die('Could not connect to database' . mysql_error());
//echo "Connected to Database";
$sql="CREATE EVENT gold ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 3 SECOND
DO
DELETE FROM table LIMIT 1;";
mysql_query($sql);
echo "done";
?>
显示回显消息完成"
但是没有执行事件查询.我也给予了特权. 刚用了3秒进行开发.
But the event query does not get executed. I have given the privileges too. Just used 3 SECOND for development purpose.
推荐答案
尝试一下:
<?php
error_reporting(E_All);
$sHost = "localhost";
$sUsername = "root";
$sPassword = "";
$sDb = "parth";
$con = mysql_connect($sHost, $sUsername, $sPassword) or die('Could not connect to MySQL server: ' . mysql_error());
echo"Connected to MySQL server";
mysql_select_db($sDb) or die('Could not connect to database' . mysql_error());
echo "Connected to Database";
$sResult = mysql_query("CREATE EVENT gold ON SCHEDULE EVERY 3 MINUTE STARTS CURRENT_TIMESTAMP + INTERVAL 3 SECOND DO DELETE FROM table LIMIT 1;") or die(mysql_error());
echo "Done";
这篇关于单击按钮创建mysql事件,每隔5分钟删除表的第一行吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文