7;your mid point
value';
You'll need a unique index or primary key on the tables.. In the above col1 is
your unique column or primary key
HTH
--- On Fri, 3/13/09, baxy77bax wrote:
> From: baxy77bax
> Subject: Re: [sqlite] how to divide a database?
> To: sqlite-users@sql
ote:
>>
>>
>> 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
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 wrote:
>
>> From: baxy77bax
>> Subject: Re: [sqlite] how to divide a database?
>> To: sqlite-users@sqlite.
t; From: baxy77bax
> 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
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
11
22
33
44
result:
db1 db2
table1 table2table
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 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 t
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.na
7 matches
Mail list logo