In message <[EMAIL PROTECTED]>, Charlie Markwick <[EMAIL PROTECTED]> writes >Thanks but this doesn't help I have no choice to run these two applications. >I would prefer it if someone could help with the question in hand:- > >Is it possible to create a means by which these two table populate each >other. > >Charlie
None of the suggestions that I have seen so far imply that you shouldn't run the two applications. Firstly, there is no "magic switch" to keep two different but similar tables in different databases in synch. I think that you said earlier that you couldn't change the databases or the applications. Is that correct? You want a third application? And how often is the customer data updated? If Application 1 and Application 2 hold differing information (client has different street address in the two tables, for example), then which data should be used? > >-----Original Message----- >From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf >Of Jay Horvitz >Sent: 08 November 2005 17:05 >To: [email protected] >Subject: Re: [php_mysql] Keeping different databases synchronised in MySQL4 > >What I would do if you wanted just one database for your customers, use >seperate IDs for each application...app1 uses cust_id1 and app2 uses >cust_id2 or something like that > > >Pete <[EMAIL PROTECTED]> wrote: >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 > -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ 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/
