INSERT INTO Product VALUES('23203','0','','','00000','10999','y623203','20001225','365','','','','6','0','0','20030814,'0',''); commit; INSERT INTO Product VALUES('23203','0','','','11000','10999','y623203','20001225','365','','','','6','0','0','20030814','0','') commit;
不要插空值('') 如果没有规律就得一条一条插INSERT INTO Product (fields1,fields2,fields5,...) VALUES('23203','0','00000',...)INSERT INTO Product (fields1,fields2,fields5,...) VALUES('23203','0','11000',...) 最后commit; 如果有规律要用过程写循环,在过程里commit;
INSERT INTO Product VALUES('23203','0','','','00000','10999','y623203','20001225','365','','','','6','0','0','20030814,'0','');
commit;
INSERT INTO Product VALUES('23203','0','','','11000','10999','y623203','20001225','365','','','','6','0','0','20030814','0','')
commit;
如果没有规律就得一条一条插INSERT INTO Product (fields1,fields2,fields5,...) VALUES('23203','0','00000',...)INSERT INTO Product (fields1,fields2,fields5,...) VALUES('23203','0','11000',...)
最后commit;
如果有规律要用过程写循环,在过程里commit;