DATE_FORMAT(date,format)
%U Week (00..53), where Sunday is the first day of the week; WEEK() mode 0
%u Week (00..53), where Monday is the first day of the week; WEEK() mode 1
Linux安装JDK7
wget http://download.oracle.com/otn-pub/java/jdk/7u75-b13/jdk-7u75-linux-x64.tar.gz?AuthParam=1428683377_f0fd3c334843ff13ba85345419ab7625 # 替换成官网实际链接
MySQL 时间顺延用法
update user set expire_date = date_add(expire_date, interval 7 day) where group_id = 1