mysql不支持select into解决
替代方案 insert into newtablename(column1,column2) select * from oldtablenameinsert 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
bitscn.com