mysql时间脚本

delimiter $$
create procedure ctas()
begin
  declare num int(2) default 0;
  while num <= 6
  do
  select date_format(date_add(now(),interval num day),'%Y%m%d'),weekday(date_add(now(),interval num day)) into @dday,@n;
  if @n <> 5 and @n <> 6 then
     select concat('ticktable_',@dday),concat('k_minute1_',@dday) into @tone,@ttwo;
     select @tone,@ttwo;
  end if;
     set num=num+1;
  end while;
  end $$
 delimiter ;

mysql时间函数的详细说明
http://www.cnblogs.com/zeroone/archive/2010/05/05/1727659.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29620572/viewspace-1800117/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29620572/viewspace-1800117/