MySQL stored procedure and timer

: This article mainly introduces the MySQL stored procedure and timer. if you are interested in the PHP Tutorial, you can refer to it. SQL is a programming language, followed by a query language. it can implement complex data operations through stored procedures.
There is a need to schedule a task and only operate on the database. for example, to regularly delete read logs, there are two ways to consider:

Using MySQL stored procedures and timers is more direct

CREATETABLE 'test '. 'log' ('id' int unsigned notnull AUTO_INCREMENT, 'MSG 'VARCHAR (255) NULL, 'isread' TINYINT (3) NOTNULLDEFAULT0 COMMENT '0 unread 1 read ', PRIMARYKEY ('id '));

Using php resident memory or regular execution [not the focus of this article]

• PHP is not limited in cli mode and can be used to schedule tasks.
• If a webpage request needs to be modified, the maximum execution time can be modified without limit;
  Ignore_user_abort (true) ensures that the program can be executed in the background after the user closes the webpage.
• Using crontab for UNIX systems

'). AddClass ('pre-numbering '). hide (); $ (this ). addClass ('Has-numbering '). parent (). append ($ numbering); for (I = 1; I <= lines; I ++) {$ numbering. append ($ ('

'). Text (I) ;}; $ numbering. fadeIn (1700) ;}) ;}; script

The above introduces the MySQL stored procedure and timer, including the content, and hope to be helpful to friends who are interested in the PHP Tutorial.