$sql1 = "SELECT SIDno FROM class WHERE SubjID='$SubjName' and SecID='$SecName'";while ($row1 = mysql_fetch_assoc($result1)){ $sql2="INSERT INTO它的工作,但它只插入一个数据到数据库中。如
我正在学习如何在mysql中创建事件,我成功地尝试了插入、更新和删除命令。但是使用SELECT语句,它不会显示输出。mysql> CREATE EVENT e_totals ON SCHEDULE AT '2013-06-04 23:59:00' DO INSERT INTO test.totals VALUES (mysql> CREATE EVENT e_totals ON SCHEDULE EVERY 30 seconds DO SELECT * FROM test.