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