mysql查询后插入数据

最新推荐文章于 2024-08-06 04:26:13 发布

yj_2006hn

最新推荐文章于 2024-08-06 04:26:13 发布

阅读量2.7k

点赞数

分类专栏： mysql 文章标签：数据 mysql select

本文链接：https://blog.csdn.net/yj_2006hn/article/details/21233101

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

方法一：insert into pur_purchase_item_config select '',id,item_code,7,15,1.5,'SYSTEM',now(),
'SYSTEM',now() from hic_item where status in (-2,1,3,5,6);
缺点：会锁表，

方法二：
SELECT * INTO OUTFILE '/tmp/20130520itemtmp.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"'
FROM (SELECT id AS item_id,item_code,7 AS safe_stock_day,15 AS single_purchase_day,1.5 AS puchase_time_factor,'SYSTEM' AS creator_name,NOW() AS gmt_create,
'SYSTEM' AS modifier_name,NOW() AS gmt_modified FROM hic_item WHERE STATUS IN (-2,1,3,5,6)) t;

LOAD DATA INFILE '/tmp/20130520itemtmp.txt' IGNORE INTO TABLE pur_purchase_item_config FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
(item_id,item_code,safe_stock_day,single_purchase_day,puchase_time_factor,creator_name,gmt_create,modifier_name,gmt_modified);
缺点：语句较复杂