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

Reply via email to