On Fri, Mar 13, 2009 at 3:21 AM, baxy77bax <b...@hi.htnet.hr> wrote: > > ok, > and how to construct a query that says; select data from table until row > number = 'middle point or so...'. > > or > > generally how to say; select 30 rows then transfer it into new table , then > select next 30 rows and do the same... and so on until you reach the end > > iteration is not such a problem but the problem is ::: > > > how to say: select 30 rows -> this is the actual question !
check out LIMIT/OFFSET > > thnx > > > > > ken-33 wrote: >> >> >> You'll need to know something about your data. You'll need the >> midpoint of each table so or at least something close. >> >> Then create two db's attach the original. And insert the data using a >> select statement with a where clause. >> >> >> >> --- On Thu, 3/12/09, baxy77bax <b...@hi.htnet.hr> wrote: >> >>> From: baxy77bax <b...@hi.htnet.hr> >>> Subject: Re: [sqlite] how to divide a database? >>> To: sqlite-users@sqlite.org >>> Date: Thursday, March 12, 2009, 4:13 PM >>> ok, i have one database with two tables and i want to create >>> two databases , >>> each with two tables in which contain half of the initial >>> data >>> >>> input: >>> >>> db >>> table1 table2 >>> aaaa 11 >>> bbbb 22 >>> cccc 33 >>> dddd 44 >>> >>> >>> result: >>> >>> db1 db2 >>> table1 table2 table1 table2 >>> aaaa 11 cccc 33 >>> bbbb 22 dddd 44 >>> >>> >>> Jim Dodgen wrote: >>> > >>> > I am confused also. >>> > >>> > Are you wanting to put half the rows from each table >>> in each database? >>> > >>> > On Thu, Mar 12, 2009 at 2:01 PM, baxy77bax >>> <b...@hi.htnet.hr> wrote: >>> >> >>> >> hi, >>> >> let say that i have one db with 2 tables in it. >>> and now i wish to divide >>> >> that database in 2 equal (half size of the >>> original) databases. two >>> >> tables >>> >> in initial database have one column. how would i >>> do that ?:confused: >>> >> any suggestions >>> >> >>> >> thank you >>> >> -- >>> >> View this message in context: >>> >> >>> http://www.nabble.com/how-to-divide-a-database--tp22485238p22485238.html >>> >> Sent from the SQLite mailing list archive at >>> Nabble.com. >>> >> >>> >> _______________________________________________ >>> >> sqlite-users mailing list >>> >> sqlite-users@sqlite.org >>> >> >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >>> > >>> > >>> > >>> > -- >>> > Jim Dodgen >>> > j...@dodgen.us >>> > _______________________________________________ >>> > sqlite-users mailing list >>> > sqlite-users@sqlite.org >>> > >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> > >>> > >>> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users