批量插入充值记录-优快云博客

本文介绍了一种使用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