Re: [sqlite] run sql file

On 11 May 2012, at 10:25am, YAN HONG YE wrote: > INSERT INTO "t" VALUES(5,'7/1/2011'); > > DELETE FROM t WHERE rowid NOT IN ( > SELECT rowid FROM >( SELECT rowid, num, date FROM t ) CROSS JOIN >( SELECT num min_num, min( date ) min_date FROM t GROUP BY num ) ON >

[sqlite] run sql file

I have a database {TABLE t( num integer, date text );} file, and a bbb.sql file content: INSERT INTO "t" VALUES(1,'1/1/2011'); INSERT INTO "t" VALUES(2,'1/1/2011'); INSERT INTO "t" VALUES(2,'2/1/2011'); INSERT INTO "t" VALUES(3,'1/1/2011'); INSERT INTO "t" VALUES(3,'2/1/2011'); INSERT INTO "t"