mysql - MySQL 事件不起作用（插入语句）

Question

我PHP用来执行SQL query，可以创建事件但没有随机数据插入到数据库中。全局事件调度程序已打开。

我的代码有什么问题吗？

我尝试做的是在创建事件后每秒将随机数据插入数据库。

下面是我的代码：

<?php

$hostname="localhost";
$username="root";
$password='xxx';
$dbname="database";

$conn= mysqli_connect($hostname,$username,$password,$dbname);

if (mysqli_connect_errno($conn)) {
    echo "Failed to connect to database: " . mysqli_connect_error();
}
else {

$query="CREATE EVENT XXX
ON SCHEDULE 
EVERY 1 SECOND
STARTS '2019-12-28 9:45:20' ON COMPLETION PRESERVE ENABLE 
DO
INSERT INTO water(Id,datetime,ph1,ec1,wt1,
ph2,ec2,wt2,
ph3,ec3,wt3,
ph4,ec4,wt4) 
VALUES(NOW(),ROUND(FLOOR(21 * RAND()) / 100, 2) + 7.40,
ROUND(FLOOR(101 * RAND()) / 10, 1) + 650,
ROUND(FLOOR(21 * RAND()) / 10, 1) + 23,
ROUND(FLOOR(21 * RAND()) / 100, 2) + 7.40,
ROUND(FLOOR(101 * RAND()) / 10, 1) + 650,
ROUND(FLOOR(21 * RAND()) / 10, 1) + 23,
ROUND(FLOOR(21 * RAND()) / 100, 2) + 7.40,
ROUND(FLOOR(101 * RAND()) / 10, 1) + 650,
ROUND(FLOOR(21 * RAND()) / 10, 1) + 23,
ROUND(FLOOR(21 * RAND()) / 100, 2) + 7.40,
ROUND(FLOOR(101 * RAND()) / 10, 1) + 650,
ROUND(FLOOR(21 * RAND()) / 10, 1) + 23);";


if(mysqli_query($conn, $query)){
    echo "successful";
}else{
    echo ("error :". mysqli_error($conn));

}



}

mysqli_close($conn);

?>

标签： mysqlmysql-event