[sqlite] Insert large data question ??

2010-05-11 Thread
Dear I have about 9 million data insert string need to insert into an table ,each row data is unique this is a sample: insert into mydata VALUES(38824801,56888,'AABBCC',4.999,157,'2009/9/10 19:55:50'); this is my schema: table|mydata|mydata|2|CREATE TABLE mydata ( itno

Re: [sqlite] Insert large data question ??

2010-05-11 Thread
P Kishor punk.k...@gmail.com: On Tue, May 11, 2010 at 12:47 AM, 風箏 ler...@gmail.com wrote: Dear I have about 9 million data insert string need to insert into an table ,each row data is unique this is a sample: insert into mydata VALUES(38824801,56888,'AABBCC',4.999,157