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 ! 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 >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/how-to-divide-a-database--tp22485238p22485445.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 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/how-to-divide-a-database--tp22485238p22492011.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