C#创建MYSQL EVENT并执行PROCEDURE
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);
[解决办法]
MySqlScript query = new MySqlScript(@"CREATE EVENT morning
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(),INTERVAL '11:00:00' HOUR_SECOND)
DO call calmorning(@p1,@p2,@p3);", conn);
query.Execute();