Hello All, I have the following table in my database
sqlite> .schema promo_new CREATE TABLE "promo_new" ( "id" integer NOT NULL PRIMARY KEY, "title" varchar(200) NOT NULL, "news_content" varchar(200) NOT NULL, "pub_date" datetime NOT NULL ); I want to enter 2000 news items at once for the testing purpose. I would like to know the shorter way out. Thanks, -- Dhruv Adhia http://thirdimension.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users