在存储过程中是否有SLEEP（）的方法？-IsthereawayforSLEEP()inastoredprocedure?

16  

I've encountered the same problem. After googling a lot, I found out that we can use

我遇到了同样的问题。经过谷歌搜索后，我发现我们可以使用

SELECT SLEEP();

to delay our procedures for this many seconds. In your case, using

延迟我们的程序这么多秒。在你的情况下，使用

SELECT SLEEP(0.2);

would be just fine.

会没事的。

2  

You can use:

您可以使用：

DO SLEEP(0.2);

Reference: http://dev.mysql.com/doc/refman/5.7/en/do.html

参考：http：//dev.mysql.com/doc/refman/5.7/en/do.html

or

要么

SELECT SLEEP(0.2);

Reference: http://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_sleep

参考：http：//dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_sleep

0  

You dont specify which database you are using, but generally the way to achive what you want is not to have an infinetly running sproc but to have some external component - like a scheduler, or SQL Server Agent in MSSQL - execute the sproc every so often.

你没有指定你正在使用哪个数据库，但一般来说，获得你想要的东西的方法不是拥有一个infinetly运行的sproc，而是拥有一些外部组件 - 比如调度程序或MSSQL中的SQL Server代理 - 每隔一段时间执行一次sproc 。

0  

I would use cron (linux) or Windows Task Scheduler (windows) to schedule it to run every minute, and have your stored procedure complete its task, then exit.

我会使用cron（linux）或Windows Task Scheduler（windows）来安排它每分钟运行一次，让你的存储过程完成它的任务，然后退出。

Having stored procs run "forever" is a really bad idea. You have long-held connections (which can die), you could inadvertently lock a table (forever), etc.

存储过程“永远”运行是一个非常糟糕的主意。你有长期连接（可能会死），你可能会无意中锁定一个表（永远），等等。

Since they have nothing to do with each other, separating your "loop" from your "task" is good design, and it means you can use (different) tools that are most appropriate for each part.

由于它们彼此无关，因此将“循环”与“任务”分开是一种很好的设计，这意味着您可以使用最适合每个部分的（不同）工具。