Kit, Do you have an example for that?
On Tue, Mar 20, 2012 at 7:48 AM, Kit <[email protected]> wrote: > Create next table with columns min, max, count and create triggers for > insert, delete and modification. > -- > Kit > > 2012/3/20, Rita <[email protected]>: > > Hello, > > > > I have a single table which has close to 4 millions rows. I write once > and > > read many times with SELECT. I mainly work with operations like max, min, > > and count so I was wondering instead of creating views is there a way I > can > > get the count() of a table and place it in a SQL variable or table? > While > > the table is getting populated I would like to build this counter. Or > have > > a SQL variable (if possible) like, count=select count(id) from table; > > > > -- > > --- Get your facts first, then you can distort them as you please.-- > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --- Get your facts first, then you can distort them as you please.-- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
