摘要:
function GetQueryString(name){ var reg = new RegExp("(^|&)"+ name +"=([^&]*)(&|$)"); var r = window.location.search.substr(1).match(reg); if(r!=null)r 阅读全文
摘要:
查看event是否开启: show variables like '%sche%'; 将事件计划开启: set global event_scheduler=1; 关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE; 开户事件任务: a 阅读全文
摘要:
select * from table where datediff('2016-06-06',FROM_UNIXTIME(‘时间字段’, '%Y-%m-%d'))<=7 AND FROM_UNIXTIME('时间字段', '%Y-%m-%d') < date('2016-06-06'); FROM 阅读全文