MySQL 存储过程和定时器

<code><span><span>CREATE</span><span>TABLE</span><span>`test`</span>.<span>`log`</span> (
  <span>`id`</span><span>INT</span> UNSIGNED <span>NOT</span><span>NULL</span> AUTO_INCREMENT,
  <span>`msg`</span><span>VARCHAR</span>(<span>255</span>) <span>NULL</span>,
  <span>`isread`</span> TINYINT(<span>3</span>) <span>NOT</span><span>NULL</span><span>DEFAULT</span><span>0</span> COMMENT <span>'0 未读 1 已读'</span>,
  <span>PRIMARY</span><span>KEY</span> (<span>`id`</span>));</span></code>