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

Reply via email to