DreamH

摘要：一、查看event是否开启show variables like '%sche%';开启event_schedulerset global event_scheduler =1;二、创建存储过程testCREATE PROCEDURE test ()BEGINupdate userinfo SET endtime = now() WHERE id = '155';END;三、创建event e_testcreate event if not exists e_teston schedule every 30 secondon completion preserv 阅读全文

摘要：DAYOFWEEK(date)　返回日期date是星期几(1=星期天,2=星期一,……7=星期六,ODBC标准)mysql> select DAYOFWEEK('1998-02-03'); -> 3WEEKDAY(date)　返回日期date是星期几(0=星期一,1=星期二,……6= 星期天)。mysql> select WEEKDAY('1997-10-04 22:23:00'); -> 5mysql> select WEEKDAY('1997-11-05'); -> 2DAYOFMONTH(date)　返回 阅读全文