C#如何如何完成以下SQL语句CREATE EVENT morning
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(),INTERVAL '11:00:00' HOUR_SECOND)
DO call calmorning(@p1,@p2,@p3);
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(),INTERVAL '11:00:00' HOUR_SECOND)
DO call calmorning(@p1,@p2,@p3);
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(),INTERVAL '11:00:00' HOUR_SECOND)
DO call calmorning(@p1,@p2,@p3);", conn);
query.Execute();
MySqlScript query = new MySqlScript(conn,@"CREATE EVENT morning
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(),INTERVAL '11:00:00' HOUR_SECOND)
DO call calmorning(@p1,@p2,@p3);");
query.Execute();
这样可以执行了多谢多谢