-----Original Message----- In message <[EMAIL PROTECTED]>, Charlie Markwick <[EMAIL PROTECTED]> writes >I am a relative newcomer to MySql and to be honest any sort of Database >admin. > >I have two separate applications that use their own databases. Each >have a table called Customer. The fields in each table are different >but contain similar data. > >The data held in each of these tables is for an identical customer >group. It is time consuming to enter the data twice. Is there any way I >can get these different tables to update each other automatically >perhaps by using a third intermediate table/database? > >Charlie
Could you use ONE table for customers? MySQL databases on the same server should have no problems about seeing each other. -- Pete Clark From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Sent: 08 November 2005 16:28 To: [email protected] Subject: Re: [php_mysql] Keeping different databases synchronised in MySQL4 Pete Thanks for getting back to me. No these are separate applications each with their own version of Customers. When I originally started thinking about it I thought about creating a sort of mapping i.e. ZipCode in DB1 = PostCode in DB2 or Address in DB1 = Address1,address2,addres3 in db2 etc But even if it was possible to do this how could I get one to update the other in real-time. It lost me at that point. Charlie ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
