Sreekumar, Regarding: > > Is it possible to insert multiple rows using a single statement ? >
You might want to let us know your reasons for requesting this. If it's speed of insertion you're after, then be sure to put many INSERT's into each transaction. That is, be sure to surround a batch of, say, 1000 INSERT's with BEGIN and END statements. http://sqlite.org/lang_transaction.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users