一条SQL插入多条数据

最新推荐文章于 2024-12-31 12:30:00 发布

原创最新推荐文章于 2024-12-31 12:30:00 发布 · 382 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL

oracle 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用SQL语句批量插入数据库中充值详情记录的方法。通过一条包含多个UNION SELECT语句的INSERT INTO...SELECT FROM DUAL命令实现，有效地提高了数据录入效率。

INSERT INTO NT_RECHARGEDETAIL(RECHARGEBATCHID,CARDNO,ACCOUNTID,AMT) SELECT 100000000035,'888123422330000001',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001797',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001798',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001799',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001800',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001801',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001802',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001803',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001804',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001805',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001806',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001807',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001808',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001809',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001810',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001811',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001812',1,111.0 FROM DUAL UNION SELECT 100000000035,'100000723010001813',1,111.0 FROM DUAL