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
一条SQL插入多条数据
最新推荐文章于 2024-08-01 09:46:22 发布