一条SQL插入多条数据

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

weiweichen

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

阅读量363

点赞数 1

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签： SQL

本文链接：https://blog.youkuaiyun.com/weiweichen/article/details/83938110

oracle 专栏收录该内容

1 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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