mysql不支持select into解决

最新推荐文章于 2022-07-10 17:32:30 发布

Rookie__Li

最新推荐文章于 2022-07-10 17:32:30 发布

阅读量1.1k

点赞数

分类专栏： mysql 文章标签： mysql

mysql 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

mysql不支持select into解决

替代方案

 
      insert 
       into 
      newTableName(column1,column2)    
      select 
      *  
      from  
       oldTableName 
     
      INSERT 
       INTO  
      `aw_daily_call_task`(tenantId,sub_product_name,  
     
      call_type,call_date,expire_date,username,customer_type,start_date,end_date,budget,product_type)  
     
      SELECT 
       t1.`tenant_id`  
      as 
       tenantId,  
     
      t1.`sub_product_name`,  
     
      1  
      as 
      call_type,  
     
      t1.`active_date`  
      as 
      call_date,  
     
      DATE_ADD(t1.`active_date`,INTERVAL 1  
      DAY 
      )  
      as 
      expire_date,  
     
      t1.`link_man`  
      as 
      username,  
     
      1  
      as 
      customer_type,  
     
      t1.`active_date`   
      as 
      start_date,  
     
      DATE_ADD(t1.`active_date`,INTERVAL t1.`remain_day`  
      DAY 
      )  
      as 
      end_date,  
     
      1  
      as 
      budget,  
     
      t1.`product_type`  
     
      FROM 
       `aw_old_products` t1