search

Home >Database >Mysql Tutorial >mysql不支持select into解决_MySQL

mysql不支持select into解决_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:31:072154browse

bitsCN.com

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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL单机load过高问题讨论_MySQLNext article：mysql查询类型转换_MySQL

Related articles

See more