一条SQL插入多条数据
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安插多条数据
一条SQL插入多条数据INSERT INTO NT_RECHARGEDETAIL(RECHARGEBATCHID,CARDNO,ACCOUNTID,AMT) SELECT 10000
