Re: Two databases with one table

[Yurii Korotia]

chen ping Wrote:
-------------------------------------------------------
> I would like to centralize the login information.
> For example: If a user signs up at website (A), he
> should be able to login to website (B)
> automatically.


if you have same structure but different logins currently, you may try to create special table for it in master database or in every database.
name merge table as your old and old one name something different

create table shared_login (a int) engine=merge union=(db1.login_tb,db2.login_tb) insert_method=last;


if you want to have 1 master table you can use next on every db for A and B sites, like

for db1 :

create table db,1master_login (a int) engine=merge union=(master_db.login_tb) insert_method=last;

for db2 looks the same:

create db2.table master_login (a int) engine=merge union=(master_db.login_tb) insert_method=last;


something like this



Edited 1 time(s). Last edit at 11/27/2012 04:45AM by Yurii Korotia.