读书人

C#创办MYSQL EVENT并执行PROCEDURE

发布时间: 2013-04-09 16:45:09 作者: rapoo

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();

读书人网 >C#

热点推荐