PHP 创建年，月，日表的脚本

1，创建年表

//加载链接MySQL的类文件 
$mysql = MysqlHelper::getInstance();

try {
//要创建的年表（cmpay_log数据库名，agent_count表名）
$initTableArr = [ 'cmpay_log.agent_count', 'cmpay_log.bank_change', 'cmpay_log.paid_log' ];

 $this_year = date("Y");
 $next_year = $this_year + 1;
 $sql = '';
 foreach ($initTableArr as $prefix) {
     $table = "{$prefix}_{$next_year}";
     $last = "{$prefix}_{$this_year}";
      $sql .= "CREATE TABLE IF NOT EXISTS {$table} LIKE {$last};";
 }
 $mysql->query($sql);


} catch (Exception $e) {
   echo $e->getMessage();
}

2，创建月表

//加载链接MySQL的类文件 
$mysql = MysqlHelper::getInstance();

try {
//要创建的月表（fm_coupon_log数据库名，t_order_log表名）
$initTableArr = [ 'fm_coupon_log.t_order_log', 'fm_coupon_log.user_loginout'];

 $this_year = date("Ym");
 $next_year = date("Ym", strtotime("+1 month"));
 $sql = '';
 foreach ($initTableArr as $prefix) {
     $table = "{$prefix}_{$next_year}";
     $last = "{$prefix}_{$this_year}";
     $sql .= "CREATE TABLE IF NOT EXISTS {$table} LIKE {$last};";
 }
 $mysql->query($sql);


} catch (Exception $e) {
   echo $e->getMessage();
}

3.创建日表

//加载链接MySQL的类文件 
$mysql = MysqlHelper::getInstance();

//创建5天的日表
$day = 5;

try {
//要创建的日表（fm_retail_log数据库名，order_log表名）
$initTableArr = ['fm_retail_log.order_log', 'fm_retail_log.order_log_extend''];

 $this_year = date("Ymd");
 $sql = '';
 foreach ($initTableArr as $prefix) {
     $last = "{$prefix}_{$this_year}";
     for ($i = 1; $i <= $day; $i++) {
             $next_year = date("Ymd", strtotime("+{$i} day"));
             $table = "{$prefix}_{$next_year}";
             $sqlDay .= "CREATE TABLE IF NOT EXISTS {$table} LIKE {$last};";
     }
 }
 $mysql->query($sql);

} catch (Exception $e) {
   echo $e->getMessage();
}